How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 37638 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / hunny
Try This :
Source -> SQ -> Sorter(Sort by Ascending on Key) -> Aggregator(Group by key Column,var=count(key colmn) - > Router(var = 1) -> Unique Target and (var > 1 ) -> Duplicates.
Make sure the Datatype for Var is not String in this scenario else will encounter operands of ambigious types mismatch error.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How identifying bottlenecks in various components of informatica and resolving them?
What is a filter transformation?
What is a standalone command task?
Explain lookup transformation in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
Define mapplet?
What is an aggregator transformation?
Define filter transformation?
Where can we find the throughput option in informatica?
What are the measure objects?
What are active transformations.
Explain the different lookup methods used in informatica?
What is parallel processing in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the types of data warehouses?
