Senior Datastage Developer Interview Questions and Answers

SCD Type 2 is implemented by creating a new record for each change in dimension attributes and maintaining a history of changes.

• Identify the dimension attributes that need to be tracked for changes

• Add a surrogate key to the dimension table

• Create a new record with a new surrogate key for each change in dimension attributes

• End-date the previous record when a new record is created

• Maintain a history of changes by keeping all previous records in the dimension table

• Use effective st...read more