how do u capture duplicates through sort & transformer
- 4 Answers
- 16862 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhash
In sort stage, we have 'create key change
column' property.
i.e, The KeyChange column is set to 1 for the first record
in each group where the value of the sort key changes.
Subsequent records in the group have the KeyChange column
set to 0.
In Transformer stage ,we can put constraint as IF KeyChange
= 1 then map to the TGT.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Datastage 7.5 and 7.0?
Have you used Unstructured data?
What is quality stage?
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
How to reverse the string using unix?
Why do we use exception activity in Datastage?
What is merge stage?
What is staging variable?
What is the difference between account and directory options ?
What are the important features of datastage?
What are the job parameters?
Notification Activity
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the use of datastage designer?
What can we do with datastage director?
