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 are the different common services in datastage?

710


How to clean the datastage repository?

702


Define project in datastage?

673


Differentiate between hash file and sequential file?

589


Have you have ever worked in unix environment and why it is useful in datastage?

657






How do you remove duplicate values in datastage?

640


What is datastage?

652


How a server job can be converted to a parallel job?

627


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

532


What could be a data source system?

583


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3387


What is the difference between datastage and datastage tx?

602


What are the difference types of stages?

633


Differentiate between odbc and drs stage?

600


how many rows sorted in sort stage by default in server jobs

3570