top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are slowly changing dimensions?

+1 vote
What are slowly changing dimensions?
posted Jun 10, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes

Data captured by Slowly Changing Dimensions (SCDs) change slowly but unpredictably, rather than according to a regular schedule. Some scenarios can cause Referential integrity problems. For example, a database may contain a fact table that stores sales records.

answer Jun 10, 2015 by Manikandan J
Similar Questions
+2 votes

Please explain in detail with example about Confirmed Dimension, Junk Dimension, Degenerated Dimension, Slowly changing Dimensions?

0 votes

i have created slowly changing dimension type 2 mapping in informatica mapping designer and i want to get active records from the loaded historical data with out using date,flag & version?