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 is the guidelines to build universe with better performance? R performance tuning issues of universes?
How can you set the session management?
What are the advantages of query studio compared to report studio?
Explain what are the various reporting tools in the market?
Explain what is difference between query studio and report studio?
What is the advantages data mining over traditional approaches?
How to test report in reportnet?
What is data validation strategies for data mart v?
What is surrogate key? Where we use it explain with example?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are the types of partitioning?
What are the data marts?
List down some of the real time data-warehousing tools?
