what is main difference between change capture and change
apply stages
Answer Posted / 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 |
Post New Answer View All Answers
What is aggtorec restructure operator?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the difference between informatica and datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What is a merge in datastage?
what is ds administrator used for?
What is the use of datastage director?
Differentiate between validated and Compiled in the Datastage?
How do y read Sequential file from job control?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the different common services in datastage?
How many types of stage?
How and where you used hash file?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How one source columns or rows to be loaded in to two different tables?