Thursday, 25 October 2012

Define slowly changing dimensions (SCD)? | ETL Testing Interview Questions

SCD are dimensions whose data changes very slowly.
eg: city or an employee.
This dimension will change very slowly.
The row of this data in the dimension can be either replaced completely without any track of old record OR a new row can be inserted, OR the change can be tracked.

No comments: