Please explain me the difference between 3 types of slowly
changing dimension in datawarehousing?
Answer Posted / venkatesh.m
scd1 ---->will contain only the updated data(ie it contains
the newly entered data + updates of historic data)it dose
not maintain historic data
scd2 ---->it contains the updated data and the historic data
(full history)
scd3 ----->it contains updated data and historic data
partially(means it may contain the records of the last
6months i think)
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
Explain entity, attribute and relationship in datastage?
How a server job can be converted to a parallel job?
What are the components of ascential data stage?
What are the types of containers in datastage?
how to sort two columns in single job in datastage.
What is size of a transaction and an array means in a datastage?
what is the use of materialized view?
Explain connectivity between datastage with datasources?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How to implement complex jobs in data stage?
What are the partitioning techniques available in link partitioner?
How to convert RGB Value to Hexadecimal values in datastage?
whom do you report?
Can you implement SCD2 using join, transformer and funnel stage?
What is the sortmerge collector?