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
- 30994 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
Explain the pipeline partition with real time example?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the use of an aggregator cache file?
How to join three sources using joiner?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is a connected transformation?
Explain sql transformation in script mode examples in informatica
Define sessions in informatica etl?
How many transformations can be used in mapplets.
In warehouses how many schemas are there?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is informatica powercenter repository?
How to partition the Session?
Explain the types of lookup transformation?
