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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to send duplicates to one target and unique rows to one
target?target is empty

Question Posted / mohan

Answer Posted / mohan

SQ-->Sorter-->Expression-->Router-->TGT

Sorter: Sort by key column(EMP_ID)
Expression:
V_OLD_EMPNO EMP_ID
V_Match IIF(EMPNO=V_OLD_EMPNO,1,0)
O_EMPNO V_MATCH

Router:
create two groups under groups tab,
Original : O_EMPNO=0
Duplicates: o_EMPNO=1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps involved in the migration from older version to newer version of Informatica Server?

2153

What are the data movement modes in informatica?

1208

What is pmcmd command?

1180

How to load data in informatica ?

1068

What is the function of look up transformation?

1174

Explian the Process of deployment groups in informatica

1102

Explain joiner transformation in informatica

1171

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

2300

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1731

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2198

Which transformation should we use to normalise the COBOL and relational sources?

1268

What is resilience time?

1227

Define Pmrep command?

1113

differences between service based and product based?

2060

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2170