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
What is the difference between an operational datastage and a data warehouse?
What are the functionalities of link partitioner?
How to read multiple files using a single datastage job if files have the same metadata?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Difference between data warehousing and olap?
How to find value from a column in a dataset?
Why fact table is in normal form?
What are the important features of datastage?
what is use of SDR function?
How can one find bugs in job sequence?
Is possible to create skid in dim,fact tables?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is the purpose of pivot stage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Name the different sorting methods in datastage.