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
- 8027 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
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Have you used Unstructured data?
What is meta stage?
how to write server Routine coding?
Highlight the main features of datastage?
Does datastage support slowly changing dimensions ?
How will you move hashed file from one location to another location?
What is usage analysis in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the differentiate between data file and descriptor file?
What is the precedence of stage variables,derivations, and constraints?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Define Routines and their types?
what are the errors,warnings in datastage
What are the stages in datastage?
