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
- 18747 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
Define data aggregation?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
root tree will find which is server job and which is parallel job?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are transforms and what is the differenece between routines and transforms?
How do you generate sequence number in datastage?
What are the different types of lookups in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What are the steps needed to create a simple basic datastage job?
Define project in datastage?
Define orabulk and bcp stages?
What is use Array size in datastage
options available in sequence job to run,validate?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Define Job control?
