what is main difference between change capture and change
apply stages
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / dharma kaveli
the stage compares two data set(after and before) and
makes a record of the differences.
change apply stage combine the changes from the change
capture stage with the original before data set to
reproduce the after data set
Is This Answer Correct ? | 20 Yes | 0 No |
Answer / 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 |
Differentiate between validated and Compiled in the Datastage?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
Triggers,VIEW,Procedures
How do u convert the columns to rows in datastage?
which r the connectors used in san?
What is the process of killing a job in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the functionalities of link partitioner?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How many types of hash files are there?
what is mapping lookup