Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to load duplicate row in a target

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


Please Help Members By Posting Answers For Below Questions

what is $$$$?

2099


How to go to the older version for a mapping?

1031


where to store informatica rejected data? How to extract the informatica rejected data?

957


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1017


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

992


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

2031


What is InformaticaPowerCenter?

1077


Clarify the utilization of aggregator cache record?

945


tell me 5 session failure in real time how can you solve that in your project?

2187


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2239


What is enterprise data warehousing?

988


COM components can be used in Informatica

2315


server hot-ws270 is connect to Repository B. What does it mean?

2442


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1509


What are the types of data warehouses?

1430