Interested to Buy Any Domain ? << Click Here >> for more details...
how to design the change capture stage in(data stage
parallel jobs) type 2
- 2 Answers
- 49322 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nidhi
1.for change capture stafe u need two input dataset one is
old one & second is the new or updated one.
2. incoming data should be sorted.
3. allow what kind of u need to check like new , delete,
change,copy.
4. if u wanna all new data should be passed to the outgoing
link then u need to specify Drop Output For insert=true.
5.there should be a change key or change key value, on the
basis of key data will be chaecked.
thanks
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
Difference between server jobs & parallel jobs?
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
Define project in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is the command line function to import and export the ds jobs?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How can we improve the performance in datastage?
Differentiate between datastage and datastage tx?
What is job control?
Which commands are used to import and export the datastage jobs?
What are the different common services in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the functionalities of link collector?
How to RD using transformer?
