Interested to Buy Any Domain ? << Click Here >> for more details...
what is main difference between change capture and change
apply stages
- 4 Answers
- 37808 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 |
I have a few records just I want to store each records tow times in target how?
How many number of reject links merge stage can have?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
I have 100 records how can I load at a time from the single time
How do you load 10 different sources with 10 different layouts to 10 different tables?
how to change left and right links in join stage?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
Teradata 
