Answer Posted / nagaraju bhatraju
take a lookup on t1 and look for dupliates in exp and
collect duplicate values to t2
or
you can hold preveious key value in variable port and can
compare it with new coming value , and you can flag these
rec as duplicate rec if both are matched , i mean previous
and current key, sorter should be used before exp as key
values should be come in sorted order only
(This technique is called forward referencing )
( Note : in other senarios if require you can use self
reference also basing on our requirements )
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
What do you mean by blocking transformation?
Which transformation should we use to normalise the COBOL and relational sources?
How does a rank transform differ from aggregator transform functions max and min?
What differs when we choose the sorted input for aggregator transformation?
Clarify the aggregator change?
What are active and passive transformations?
What is native users?
What is the maplet?
How many ways a relational source definition can be updated and what are they?
Explain Dataware house architecture .how data flow from intial to end?
What is the use of target designer?
COM components can be used in Informatica
Where do we use mapping variables in informatica?
What is the function of union transformation?
