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
- 8032 Views
- MGL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
The Change Capture 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. The stage produces a change data set, whose table definition is transferred from the after data set’s table definition with the addition of one column: a change code with values encoding the four actions: insert, delete, copy, and edit. The preserve-partitioning flag is set on the change data set.
Copy code:
Allows you to specify an alternative value for the code that indicates the after record is a copy of the before record. By default this code is 0.
Deleted code:
Allows you to specify an alternative value for the code that indicates that a record in the before set has been deleted from the after set. By default this code is 2.
Edit code:
Allows you to specify an alternative value for the code that indicates the after record is an edited version of the before record. By default this code is 3.
Insert Code:
Allows you to specify an alternative value for the code that indicates a new record has been inserted in the after set that did not exist in the before set. By default this code is 1.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Can you explain how could anyone drop the index before loading the data in target in datastage?
why do u need the IOS upgradation in a FC switch
AGGREGATOR default datatype
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
Describe the main features of datastage?
What are the processing stages?
sed,awk,head
Explain entity, attribute and relationship in datastage?
1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?
6 Answers CTS, HCL, IBM, Wipro,
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
Explain briefly scd type2 in datastage7.5x2(parallel)
how can we join one oracle & flat files ?
Teradata 
