Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7908 Views
- MGL, I also Faced
- E-Mail Answers
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
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Where the datastage stored his repository?
describe the Steps to confiure a Qlogic switch
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are the enhancements made in datastage 7.5 compare with 7.0?
Distinguish between informatica & datastage. Which one would you choose and why?
What is quality stage?
Difference between server jobs & parallel jobs?
What is meta stage?
Define project in datastage?
Is it possible to query a hash file?
How many types of hash files are there?
How to implement complex jobs in data stage?
What is a ds designer?
How do you import and export the datastage jobs?
