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 |
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
What is datastage engine?
What is a delta record? How you will read it?
how can you generate sequence number using only the sequential file stage?
How do y read Sequential file from job control?
What are the types of containers in datastage?
how to retrive the max(sal),deptno,empno in datastage?
What are iconv and oconv?
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
Differentiate between hash file and sequential file?
Explain the scenarios where sequential file stage runs in parallel?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?