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
- 6319 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 |
Enlist various types of routines in datastage.
How you can fix the truncated data error in datastage?
options available in sequence job to run,validate?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
what is the Difference Between Datastage Server Edition and Parallel Edition?
in aggregator , how can i get the sum in readable format
how can we create tables in datastage?
What is the purpose of pivot stage?
What all the types of jobs you developed?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
Teradata 
