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
- 7931 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
How many types of sorting methods are available in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
Name the different types of Lookups in Datastage?
Differentiate between hash file and sequential file?
What is aggtorec restructure operator?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How do you import and export the datastage jobs?
Explain the situation where you have applied SCD in your project?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
table actions available in oracle connector?
Difference between in process and inter process?
Triggers,VIEW,Procedures
Can you explain engine tier in information server?
