Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7786 Views
- MGL, I also Faced
- E-Mail Answers
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
Differentiate between data file and descriptor file?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Name the different types of Lookups in Datastage?
Difference between server jobs & parallel jobs?
How many types of hash files are there?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
what is the use of surogate key 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
what are the errors,warnings in datastage
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the differences between datastage and informatica?
Explain usage analysis in datastage?
What is the different type of jobs in datastage?
what is the use of materialized view?
client know skid info?
