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
how do u catch bad rows from OCI stage? And what CLI stands for?
What are orabulk and bcp stages?
in oracle target stage when we use load option and when we use upsert option?
What is the method of removing duplicates, without the remove duplicate stage?
Can you filter data in hashed file?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Is possible to create skid in dim,fact tables?
What are the primary usages of datastage tool?
How to implement complex jobs in data stage?
What are the components of ascential data stage?
how to abort the job its matain duplicates?
How a routine is called in datastage job?
How do you generate sequence number in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
How many areas for files does datastage have?