Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain me the difference between 3 types of slowly
changing dimension in datawarehousing?
- 3 Answers
- 18709 Views
- TCS, I also Faced
- E-Mail Answers
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
How to manage date conversion in Datastage?
What is oci?
What a datastage macro?
Can we use target hash file as a lookup ?
how do u catch bad rows from OCI stage? And what CLI stands for?
Whats difference betweeen operational data stage (ods) and data warehouse?
what is use of SDR function?
How a server job can be converted to a parallel job?
How many areas for files does datastage have?
What is the difference between operational data stage (ods) and data warehouse?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the types of containers?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Can you implement SCD2 using join, transformer and funnel stage?
