Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 40670 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 ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is an unconnected transformation?
What is mapplet in informatica?
What is the different lookup cache(s)?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are data-driven sessions?
How to update or delete the rows in a target, which do not have key fields?
what are factless facts? And in which scenario will you use such kinds of fact tables.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the difference between router and filter?
What are the different ways to implement parallel processing in informatica?
Explain the tuning lookup transformation - informatica
What is a sequence generator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What are multi-group transformations?
What is joiner transformation?
