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
- 6236 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 a routine is called in datastage job?
What is the difference between hashfile and sequential file?
Define ds designer?
How do you import and export the datastage jobs?
What is active and passive stage?
How can you write parallel routines in datastage PX?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are some prerequisites for datastage?
What are the types of jobs we have in datastage?
What are iconv and oconv?
Differentiate between hash file and sequential file?
What all the types of jobs you developed?
What are the differences between datastage and informatica?
What is the importance of the exception activity in datastage?
