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
How to create the source and target database connections in server manager?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is a surrogate key?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is a repository? And how to add it in an informatica client?
Which files are created during the session rums by informatics server?
Define mapplet?
Explain incremental aggregation in informatica
Separate from a database, an information bazaar, and an information stockroom?
Tell me about Propagate functions in informatica
What is primary and backup node?
Performance tuning in UNIX for informatica mappings?
What can we do to improve the performance of informatica aggregator transformation?
Is stop and abort are same in informatica?
What are active transformations.