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 many types of sorting methods are available in datastage?
Explain datastage architecture?
Differentiate between hash file and sequential file?
Is possible to create skid in dim,fact tables?
CHANGE CAPTURE
What are the types of views in datastage director?
how to write server Routine coding?
What is the difference between odbc and drs stage?
What are the functionalities of link collector?
Explain ibm infosphere information server and highlight its main features?
How to find value from a column in a dataset?
what is use of SDR function?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define ds designer?
how can we create rank using datastage?what is the meaning of rank?