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 send duplicates to one target and unique rows to one
target?target is empty

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

How to create the source and target database connections in server manager?

1098


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

2116


What is a surrogate key?

1091


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1096


What is a repository? And how to add it in an informatica client?

1153


Which files are created during the session rums by informatics server?

1189


Define mapplet?

1019


Explain incremental aggregation in informatica

1140


Separate from a database, an information bazaar, and an information stockroom?

1093


Tell me about Propagate functions in informatica

929


What is primary and backup node?

1137


Performance tuning in UNIX for informatica mappings?

2575


What can we do to improve the performance of informatica aggregator transformation?

1101


Is stop and abort are same in informatica?

1009


What are active transformations.

1659