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
- 6327 Views
- IBM, I also Faced
- E-Mail Answers
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 |
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
What are orabulk and bcp stages?
What are the different types of lookups in datastage?
what is the use of surogate key in datastage
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
How to lode data in sequntional files perform faster?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
What is the flow of loading data into fact & dimensional tables?
which unix commands mostly used in datastage
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
Teradata 
