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
- 41684 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
Which transformation is needed while using the Cobol sources as source definitions?
What are the uses of etl tools?
What is the scenario which compels informatica server to reject files?
How big was your fact table
What is informatica worklet?
How to update source definition?
Explain in detail scd type 2 through mapping.
Can we override a native sql query within informatica?
While migrating the data from one environment to another environment how would you manage the connections?
How to go to the older version for a mapping?
Can u generate reports in Informatica?
What is enterprise data warehousing?
Is it possible to revert a global repository to local one and why?
Differentiate between Load Manager and DTM?
What is pmcmd command?
