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
- 18734 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
How complex jobs are implemented in datstage to improve performance?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Have you have ever worked in unix environment and why it is useful in datastage?
how to delete one row in target dataset
Define orabulk and bcp stages?
what is the use of surogate key in datastage
What is the purpose of pivot stage and types of containers in datastage
How one source columns or rows to be loaded in to two different tables?
What is the use of datastage director?
How to perform incremental load in datastage?
Why fact table is in normal form?
How many types of hash files are there?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Define Job control?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
