Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rashmirekha panigrahy
In SCD Type2 we keep the entire historical data in the dimension table whereas in SCD Type3 we keep partial historical data in the dimension table.
For Ex : Suppose we are having a Customer Table. Acustomer 1st staying at Los Angels. Then he is shifted to DEllas. again he is shifted to Texas.
In case of Type 2 if we are using date method it will show the location and how many days he stayed on that particular location.
Sk_C Cust_ID Cust_NM Location Start_Dt End_DT
101 200345 Williams Los Angels 01-Mar-2011 23-Jun-2012
678 200345 Williams Dellas 24-Jun-2012 12-Nov-2014
1562 200345 Williams Texas 13-Nov-2014 NULL
But In case of Type 3 we will keep only current location and previous location. Not more than that.
Sk_C Cust_ID Cust_NM Cur_Location Pre_Location
101 200345 Williams Los Angels NULL
He shifted to Dellas.
Sk_C Cust_ID Cust_NM Cur_Location Pre_Location
101 200345 Williams Dellas Los Angels
Again he shifted to Texas.
Sk_C Cust_ID Cust_NM Cur_Location Pre_Location
101 200345 Williams Texas Dellas
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is dimension modeling?
Explain what are the various file formats involved in reportnet?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Explain the differences between normalizer and normalizer transformation?
How can we load the time dimension?
How many project sources we can create in metadata?
Explain what are the mapping paramaters and maping variables?
What are target types on the server?
What is a full backup?
Explain can report net connect multiple datasource at a time in report creation time?
Explain what is the difference between powerplay transformer and power play reports?
How to design file watch jobs?
What are diagrams?
Explain ddl (data definition language)?
What is the very basic difference between data warehouse and operational databases?
