Nitor Infotech Senior Sse Software Engineering Analyst Interview Questions and Answers

Loading data incrementally involves updating only new or changed data instead of reloading entire dataset.

• Identify the key field that determines new or updated records

• Use timestamp or versioning to track changes

• Implement a process to extract, transform, and load only new or updated data

• Consider using tools like Change Data Capture (CDC) or Incremental Load in ETL processes

SCD types refer to slowly changing dimensions in data warehousing, categorized into Type 1, Type 2, and Type 3.

• Type 1: Overwrite existing data with new data, losing historical information.

• Type 2: Create a new record for each change, preserving historical data with a new surrogate key.

• Type 3: Maintain both old and new values in separate columns within the same record.