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
- 6822 Views
- MGL, I also Faced
- E-Mail Answers
Answer Posted / pranay
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 |
Post New Answer View All Answers
Does datastage support slowly changing dimensions ?
What is the purpose of pivot stage and types of containers in datastage
How do you import and export the datastage jobs?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are constraints and derivations?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How can one find bugs in job sequence?
options available in sequence job to run,validate?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
what is the difference between == and eq in UNIX shell scripting?
What are the components of ascential data stage?
Is possible to create skid in dim,fact tables?
How a routine is called in datastage job?
What is the difference between validated and compiled in the datastage?
What is the difference between hashfile and sequential file?
