Interested to Buy Any Domain ? << Click Here >> for more details...
how do u capture duplicates through sort & transformer
- 4 Answers
- 18754 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
Hai..,
In sort stage we have one property...its create key change
column.
In Transformer stage ,we have to write if then else
condition.....
| Is This Answer Correct ? | 11 Yes | 1 No |
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 |
Answer / harikiran
in transformer stage output properties tab there is a
sorting option if u mention sort option there are two more
operations are there like unique and stable sort. if u
click on uniqu it will restrict the duplicates
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the difference between datastage and datastage tx?
root tree will find which is server job and which is parallel job?
what is the use of skid in reporting?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are routines in datastage?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
What is the difference between Datastage 7.5 and 7.0?
what is the diff between sequential file and fileset stages?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
what is a nodemap constraint
Teradata 
