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
- 41187 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
How to update a particular record in target with out running whole workflow?
What is data transformation manager process?
What do you mean by blocking transformation?
What are active transformations.
What is DR strategy for Informatica project?
What is sequence generator transformation in informatica?
What is a predefined event?
Write the unconnected lookup syntax and how to return more than one column.
Scheduling properties,whats the default (sequential)
How can you generate reports in informatica?
Define enterprise data warehousing?
What is the reusable transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain transaction control transformation in informatica
How to go to the older version for a mapping?
