|
Define the term slowly changing dimensions (SCD)Slowly changing dimension target operator is one of the SQL warehousing operators that can be used in mining flow or in data flow.
When the attribute for a record varies over time, the SCD is applied.
Define the term slowly changing dimensions (SCD).SCD are dimensions whose data changes very slowly. An example of this can be city of 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.
|
