State Street Corporation Lead Engineer Interview Questions and Answers for Experienced

LOD stands for Level of Detail. It is a technique in Tableau that allows users to compute values at a different level than the view.

• LOD expressions can be used to aggregate data at a higher level than the view, or to compute values at a lower level than the view.

• There are three types of LOD expressions: FIXED, INCLUDE, and EXCLUDE.

• FIXED LOD expressions compute values using a specified set of dimensions, regardless of t...read more

Hyper is a data engine used by Tableau to process large amounts of data quickly.

• Hyper is an in-memory data engine that can process billions of rows of data.

• It allows for faster data analysis and visualization.

• Hyper can handle complex queries and calculations.

• Tableau uses Hyper as its default data engine since version 10.5.

• Hyper can also be used as a standalone database.

• Hyper supports various data sources including CSV,

Parameters in Tableau are dynamic inputs that allow users to change values in a visualization.

• Parameters can be used to filter data, change calculations, and control the appearance of a visualization.

• They can be created by right-clicking on a field or by using the 'Create Parameter' option in the 'Analysis' menu.

• Examples of parameters include allowing users to select a date range, adjusting the size of a chart, or chan...read more

To make a class immutable, we need to ensure that its state cannot be modified after creation.

• Make all fields private and final

• Do not provide any setters

• If mutable objects are used, return copies instead of references

• Ensure that any methods that modify state return a new instance instead of modifying the existing one

Threads are lightweight processes that share memory and resources, while processes are independent and have their own memory and resources.

• Threads are a part of a process and share the same memory space.

• Processes are independent and have their own memory space.

• Threads are faster to create and switch between than processes.

• Processes are more secure and stable than threads.

• Examples of processes include web browsers and t...read more