while we using change capture stage we have to be take two
table thats are 1.before table 2. after table .
what is before table and after table
please give me clear notation
Thank You very much in advance
Answer Posted / akila
Adding to the answer above, to check if the same records
are present in both the datasets we have to specify keys.
If the same keys are present in both the files, then it
is 'Copy'/'Edit', if the keys are present in before but not
after then it is a 'delete', if the keys are there in after
but not in new then it is an 'insert'.
To decide if the record is a copy or edit you have to
specify change key. If the main keys match and teh change
key also matches, then it is a 'copy'. If not, then it is
a 'edit'.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define repository tables in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How to implement complex jobs in data stage?
Differentiate between hash file and sequential file?
AGGREGATOR default datatype
What is the difference between in process and inter process?
What are the important features of datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the steps required to kill the job in Datastage?
What are the different common services in datastage?
How to perform incremental load in datastage?
What are the main features of datastage?
How many types of views are there in a datastage director?
How many areas for files does datastage have?
how to write server Routine coding?