How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 28049 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohan
Here is the minor modification on Answer #6 posted by me,
SQ-->Sorter-->Expression-->Router-->Targets
Sorter Transformation: Sort by key column(EMP_ID)
Expression Transformation:
V_Match(variable port) =IIF(EMPNO=V_OLD_EMPNO,1,0)
V_OLD_EMPNO(Variable)= EMP_ID
O_EMPNO(output)= V_MATCH
Router Transformation:
create two groups under groups tab,
Original : O_EMPNO=0
Duplicates: o_EMPNO=1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
design of staging area?
How can informatica be used for an organization?
draw informatica architecture 8.6 ?
Why union transformation is an active transformation?
How to extract sap data using informatica? What is abap? What are idocs?
Why filter transformation is an active one?
How to open an older version of an object in the workspace?
What is the fact table?
What are the informatica performance improvement tips
Explain pushdown optimization $pushdownconfig parameter - informatica
What can we do to improve the performance of informatica aggregator transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
what is the -ve test case in your project.
Implementation methodology
Design a mapping to load the cumulative sum of salaries of employees into target table?
