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
- 7916 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
Define repository tables in datastage?
How complex jobs are implemented in datstage to improve performance?
How do you register plug-ins?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How do you start developing a datastage project?
Difference between sequential file and data set?
what are the devoleper roles in real time? plz tell i am new to datastage....
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the different type of jobs in datastage?
What is a merge in datastage?
What are routines in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to implement complex jobs in data stage?
