Interested to Buy Any Domain ? << Click Here >> for more details...
How u implement the slowly changing dimensions if my source
table is consisting of cid,cname,add,phno,email but i need to
capture the changes for first three columns how u implement?
- 1 Answers
- 6333 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
This is done by using the Change_Capture_Stage.
In the CDS stage: specify the change key's--> cid and
change_values as cname,add and phone etc
CDC stage triggers the Change_code as 3 if there is any
changes in the cname or add or phone no for the existing cid.
Ex: cid,cname,add,phone,email
1,'vin','bang','08979','vin@Gmail.com'
REf:
cid,cname,add,phone,email
1,'vin','HYD','08979','vin@Gmail.com'
O/P: cid,cname,add,phone,email,Change_code
1,'vin','HYD','08979','vin@Gmail.com',3
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How to reverse the string using unix?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How and where you used hash file?
What are the types of jobs we have in datastage?
Why fact table is in normal form?
Define ds designer?
What is ibm datastage flow designer?
What is difference between symmetric multiprocessing and massive parallel processing?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
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
What is the precedence of stage variables,derivations, and constraints?
Does datastage support slowly changing dimensions ?
Have you have ever worked in unix environment and why it is useful in datastage?
how to add a new records into source?
