How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 28117 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 are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to generate sequence numbers without using the sequence generator transformation?
What is meant by lookup transformation?
What do you understand by a term domain?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How might you approve all mappings in the archive all the while?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the types of data warehouses?
Clarify the utilization of aggregator cache record?
Explain incremental aggregation in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are data-driven sessions?
Why union transformation is an active transformation?
What is main use of mapplet?
