Please explain me the difference between 3 types of slowly
changing dimension in datawarehousing?
Answer Posted / sowmi
scd 1:It wont implement the new change.It always contains
the historic data alone.
scd 2:It will replace or overwrite the existing record.It
will not contain the historic data.But it has surrogate key.
scd 3:It contains both the old data and a new record with
the modified information and has additional columns like
"effective start date and end date" or "version no".
Please correct me if i am wrong
Is This Answer Correct ? | 0 Yes | 20 No |
Post New Answer View All Answers
What are the features of datastage flow designer?
Where the datastage stored his repository?
How do you run datastage job from the command line?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
what is repositery?
How can you write parallel routines in datastage PX?
What are the main differences you have observed between 7.x and 8.x version of datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Differentiate between data file and descriptor file?
What is the difference between in process and inter process?
Why do we use link partitioner and link collector in datastage?
What are the types of containers and how to create them?
Explain the importance of surrogate key in data warehousing?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Define project in datastage?