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
- 9 Answers
- 30934 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
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 call shell scripts from informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Which transformation should we use to normalise the COBOL and relational sources?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain sessions?
What do think which one is the better joiner or look up?
What is a standalone command task?
What is a mapplet/worklet in informatica?
How to do unit testing in informatica? How to load data in informatica ?
Different sorts of metadata that stores in the storage facility?
What is intricate mapping?
Implementation methodology
Why do you use Mapping Parameter and mapping variable?
Which is the t/r that builts only single cache memory?
What do you mean by enterprise data warehousing?
