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
- 18563 Views
- TCS, I also Faced
- E-Mail Answers
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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
what is the use of materialized view?
What are the enhancements made in datastage 7.5 compare with 7.0?
How a source file is populated?
Have you have ever worked in unix environment and why it is useful in datastage?
Can you define merge?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Define project in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how do u catch bad rows from OCI stage? And what CLI stands for?
Define repository tables in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Differentiate between validated and Compiled in the Datastage?
What are the different kinds of views available in a datastage director?
