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
- 6320 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
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the difference between passive stage and active stage?
Difference between sequential file and data set?
Difference between server jobs & parallel jobs?
How do u convert the columns to rows in datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Can you explain kafka connector?
what is the use of materialized view?
Describe the main features of datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the repository tables in datastage?
Explain usage analysis in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is active and passive stage?
Enlist various types of routines in datastage.
