what is main difference between change capture and change
apply stages
- 4 Answers
- 36244 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is the sortmerge collector?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
difference between function and procedure...
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How do you generate sequence number in datastage?
how can we join one oracle & flat files ?
What are the different database update actions available?
Differentiate between datastage and informatica?
job locking methods? How can we unlock the job?
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
Teradata 
