while we using change capture stage we have to be take two
table thats are 1.before table 2. after table .
what is before table and after table
please give me clear notation
Thank You very much in advance
Answer Posted / akila
Adding to the answer above, to check if the same records
are present in both the datasets we have to specify keys.
If the same keys are present in both the files, then it
is 'Copy'/'Edit', if the keys are present in before but not
after then it is a 'delete', if the keys are there in after
but not in new then it is an 'insert'.
To decide if the record is a copy or edit you have to
specify change key. If the main keys match and teh change
key also matches, then it is a 'copy'. If not, then it is
a 'edit'.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between data file and descriptor file?
Define meta stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is merge stage?
How can you write parallel routines in datastage PX?
What is the purpose of pivot stage?
Differentiate between datastage and datastage tx?
explain about citrix scheduling tool in datastage
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the purpose of interprocessor stage in server jobs?
What are the types of containers in datastage?
how to export or import the jobs in .ISX file
How to Remove Duplicate using SQL?
How many types of hash files are there?
Highlight the main features of datastage?