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
what is the difference between == and eq in UNIX shell scripting?
Differentiate between operational datastage (ods) and data warehouse?
What are the types of containers and how to create them?
how to export or import the jobs in .ISX file
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Is possible to create skid in dim,fact tables?
Can you highlight the main features of ibm infosphere information server?
what is the use of surogate key in datastage
What are the features of datastage flow designer?
How to implement complex jobs in data stage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Does datastage support slowly changing dimensions ?
Describe link sort?
What is the different type of jobs in datastage?
What is the difference between an operational datastage and a data warehouse?