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 can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?

Answer Posted / roshan

hey u have to write a stored procedure to compare each record and then use a router T/R, if the record is non duplicated then it sends to one target and duplicated records to another target.. hope it works..
let me know if better option is available..
infernonag@gmail.com

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the performance considerations when working with aggregator transformation?

1110


How many numbers of sessions can one group in batches?

1035


What you know about transaction control transformation?

953


What are mapplets?

1220


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1599


What is data caches/ index caches?

1034


What is informatica worklet?

1001


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1737


Explain dynamic target flat file name generation in informatica

1021


Can anyone tell me the new features in Informatica 9 Version?

2053


How to start a workflow using pmcmd command?

1199


What do you mean by filter transformation?

911


What is the sequence generator transformation in informatica?

1113


What is a grid in Informatica?

1014


Where is metadata stored?

1059