top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Ln which situations do you go for scds ?

+1 vote
26 views
Ln which situations do you go for scds ?
posted May 20, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

Slowly changing dimensions are dimension tables that have slowly increasing dimension data, as well as updates to existing dimensions. Ex : if a person Mr. x is living in the city C1 has a transaction in a bank and his details is maintained and after some years he moves to city C4, that means he has his new details develped but the bank need to maintain the details i.e both c1 and c2 details ,the history has to be maintained fully or sometimes partially , so in this cases the necessity of SCD is required

When updating existing dimensions, you decide whether to keep all historical dimension data, no historical data, or just the current and previous versions of dimension data.

answer May 25, 2015 by Shweta Singh
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...