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 important features of datastage?
in oracle target stage when we use load option and when we use upsert option?
Demonstrate experience in maintaining quality process standards?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the benefits of datastage?
What are sequencers?
Name the different types of Lookups in Datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How do you start developing a datastage project?
How to Remove Duplicate using SQL?
Differentiate between data file and descriptor file?
What are the different type of jobs in datastage?
What are the main features of datastage?
What all the types of jobs you developed?