MassMutual Data Engineer Interview Questions and Answers

Dimensions and facts are two types of data in a data warehouse. Dimensions are descriptive attributes while facts are measurable data.

• Dimensions are used to categorize and filter data while facts are used to perform calculations and analysis.

• Dimensions are often used as the basis for reports and dashboards while facts are used to provide the underlying data.

• Examples of dimensions include time, location, and product whi...read more

Informatica Router and Union are used for data integration and transformation.

• Informatica Router is used to route data based on certain conditions.

• Informatica Union is used to combine data from multiple sources.

• Router can be used to split data into multiple targets based on conditions.

• Union can be used to merge data from multiple sources into a single target.

• Router can be used to implement complex data flows.

• Union can

Find employee details with max salary in each department.

• Group employees by department

• Find max salary for each group

• Join with employee details to get employee info