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
- 30935 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
What is data transformation manager process?
Did u used latest transformations of 8.6.0? for what?
Target increases every day even though no new record was inserted
Sequence generator, when you move from develoment to production how will you reset
Clarify the aggregator change?
Define the various join types of joiner transformation?
When do you use sql override in a lookup transformation?
In warehouses how many schemas are there?
How many input parameters can exist in an unconnected lookup?
Define joiner transformation?
what is mean by complex business rule ?
How can we store previous session logs?
Can u generate reports in Informatica?
Is it possible to create multiple domains on a single Informatica server?
Differentiate between a repository server and a powerhouse?
