What is the Difference between Change capture stage and
Difference Stage ? What are its significance individually ?
Answer / rakesh gupta
There is not much difference between cdc stage and difference stage.Both the stage similar.
Difference between cdc stage and difference are following:-
1.In CDC stage,we should have same number of columns and same column name from both the input link.However,In difference stage we can have different number of column and Different column name.
2.The CDC stage takes two input data sets, denoted before and after, and outputs a single data set whose records represent the changes made to the before data set to obtain the after data set.However,Difference stage performs a record-by-record comparison of two input data sets, which are different versions of the same data set designated the before and after data sets. The Difference stage outputs a single data set whose records represent the difference between them.
Is This Answer Correct ? | 6 Yes | 10 No |
source file contains 100 records, i want 10 records in target file how it possible in datastage
Define ds designer?
What are the stages in datastage?
How to generate surrogate key without using surrogate key stage?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
Why we use parameters instead of hard code in datastage.
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
options available in sequence job to run,validate?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
What modeling tool do you use?
how to identifie,is it innerjoin,leftouter join in lookup?