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 extract original records at one target & Duplicate
records at one target?

Answer Posted / shankar

First Pipeline:

SQ--Sort---Tgt1

Second Pipeline:

SQ--Lkp on Tgt1--If The value is matched from both the table
send it to Tgt2.

Use target load plan while u run the session...

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2428


What are the popular informatica products?

1015


What are the advantages of informatica?

1014


What is the sql query overwrite in source qualifier in informatica

1097


Explain dynamic target flat file name generation in informatica

1063


Did u used latest transformations of 8.6.0? for what?

1884


What are the tuning techniques you applied during your last project

2029


What is a surrogate key?

1089


How do you convert single row from source into three rows into target?

1162


What all join we can perform in LOOKUP transformation?

986


What are the different lookup cache(s)?

1123


Why union transformation is an active transformation?

1050


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

2108


How to load last n records of file into target table - informatica

1083


Can we create a node as a gateway node and the same node can be assigned to a grid?

1085