what is main difference between change capture and change apply stages

what is main difference between change capture and change
apply stages

Question Posted / chlaxmanmca

4 Answers
35680 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is main difference between change capture and change apply stages..

Answer / shady

change capture stage catch holds of changesfrom two
different datasets and generates a new column called change
code....change code has values
0-copy
1-insert
2-delete
3-edit/update

where as change apply stage applies these changes back to
those data sets based on the chanecode column

Is This Answer Correct ?

40 Yes

2 No

what is main difference between change capture and change apply stages..

Answer / dharma kaveli

the stage compares two data set(after and before) and
makes a record of the differences.
change apply stage combine the changes from the change
capture stage with the original before data set to
reproduce the after data set

Is This Answer Correct ?

20 Yes

0 No

what is main difference between change capture and change apply stages..

Answer / abdullah

read answer 2 first because i`m appending this answer to it so u can understand more.

*change capture views you the records that were change only, without telling you the rest of of the original records
ex: if one records was changed among 5 records then it will view it alone.
-(it will take two input, the before data set and the after data set)

*change apply should take the original data set and the change capture data set and then apply the change to the original copy as an output. as a result you have now all the records including the new and changed ones.

Is This Answer Correct ?

3 Yes

0 No

what is main difference between change capture and change apply stages..

Answer / vin

please explain in a detailed manner

Is This Answer Correct ?

7 Yes

5 No

Post New Answer