what is main difference between change capture and change
apply stages

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is ds administrator used for?

720


EXPLAIN SCD

960


What are the steps needed to create a simple basic datastage job?

656


What is the difference between server job and parallel jobs?

663


What are the types of jobs we have in datastage?

668






Have you used Unstructured data?

830


Differentiate between datastage and datastage tx?

591


What is process model?

1551


Different ways a project can be moved to production ?...example ….export-import and Version control.

1931


How do you register plug-ins?

598


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

1118


State the difference between an operational datastage and a data warehouse?

602


Can you explain how could anyone drop the index before loading the data in target in datastage?

892


Explain Quality stage?

666


What are the stages in datastage?

635