Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between Change capture stage and
Difference Stage ? What are its significance individually ?
- 1 Answers
- 21428 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of hoursfromtime() function in transformer stage in datastage?
What are datastage sequences?
What is the difference between validated and compiled in the datastage?
Define meta stage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the importance of the exception activity in datastage?
What is the process of killing a job in datastage?
What is apt_config in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are some prerequisites for datastage?
Is the value of staging variable stored temporarily or permanently?
What is data partitioning?
What is the difference between server job and parallel jobs?
What are data elements?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
