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
Is there any way to read the ms excel datas directly into informatica?
What is deployment group?
What do you mean by channel change?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What do you mean by worklet?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
can any one give some examples for pre sql and post sql(Except dropping and creating index).
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
4 yrs etl devloper roles and responsibilities?any body give solutions
Write the prerequisite tasks to achieve the session partition?
How do you load alternate records into different tables through mapping flow?
Please let me know how to make encryption and decryption with example?
Performance tuning( what you did in performance tuning)
What is a rank transform?
Define mapping and session?
