how to design the change capture stage in(data stage
parallel jobs) type 2
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
Explain usage analysis in datastage?
What is oci?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
how to export or import the jobs in .ISX file
root tree will find which is server job and which is parallel job?
What are the differences between datastage and informatica?
What are the various kinds of the hash file?
How do you register plug-ins?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are stage variables, derivations and constants?
what is flow of project?
How many types of hash files are there?
What is ibm datastage?
Why do we use link partitioner and link collector in datastage?