how do u capture duplicates through sort & transformer

Question Posted / raam

4 Answers
16886 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how do u capture duplicates through sort & transformer..

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

how do u capture duplicates through sort & transformer..

Answer / 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

how do u capture duplicates through sort & transformer..

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

how do u capture duplicates through sort & transformer..

Answer / kalyanreddy

Yes, Kirans is right

Is This Answer Correct ?

0 Yes

1 No

Post New Answer