WNS Group Manager Interview Questions and Answers

Q1. Design incremental load in Databricks.
Ans. 
Incremental load in Databricks involves updating only new or changed data since the last load.
• Use change data capture (CDC) to identify new or updated records.

• Leverage Databricks Delta for managing the incremental load process.

• Implement a merge operation to update existing records and insert new records efficiently.

• Utilize partitioning and clustering to optimize performance of incremental loads.
Answered by AI
Add your answer
Q2. Implement SCD2 in data warehouse
Ans. 
SCD2 is a type of slowly changing dimension in data warehousing to track historical data changes.
• Use effective dating to track changes over time

• Add new records for changes instead of updating existing ones

• Include attributes like start date, end date, and version number

• Maintain history of changes for auditing purposes
Answered by AI
Add your answer

For content, you are given a written and editing test

Q1. Regular questions..nothing interesting
Add your answer

Q1. Question related to statistics and ML algorithms
Add your answer
Q2. Question related to python and R coding
Add your answer