Interested to Buy Any Domain ? << Click Here >> for more details...
what is main difference between change capture and change
apply stages
- 4 Answers
- 37845 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 |
can any one tell me how to install datastage 8.1 in windows xp with wizard
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
What is use Array size in datastage
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
Define oconv () and iconv () functions in datastage?
which r the connectors used in san?
Demonstrate experience in maintaining quality process standards?
Terminate Activity
How to convert alpha Numeric values to alpha using functions?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Teradata 
