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
what is $$$$?
How to go to the older version for a mapping?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is InformaticaPowerCenter?
Clarify the utilization of aggregator cache record?
tell me 5 session failure in real time how can you solve that in your project?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is enterprise data warehousing?
COM components can be used in Informatica
server hot-ws270 is connect to Repository B. What does it mean?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the types of data warehouses?