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 fact less fact table? Where you have used it in your project?
What is data stream and data adaopter?
Explain datawarehousing?
What is a functional dependency f said to be minimal?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What are necessary tasks to install reportnet software?
Explain what are non-additive facts?
What are the data types present in bo?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
if you use oracle sql*loader , how do you transform data with it during loading?
What is the difference between er modeling and dimensional modeling?
What is the use of incremental aggregation? Explain me in brief with an example?
What is a full backup?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
