How we can get unique records into one target table and
duplicate records into another target table??
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
expain about the tune parameters?
What is depict expression change?
How union transformation is used?
How can you differentiate between powercenter and power map?
How many transformations can be used in mapplets.
Enterprise data warehouse your projects phase by phase explain?
Can u generate reports in Informatica?
What is joiner transformation?
What are the components of the workflow manager?
On which transformations you created partitions in your project?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain scd type 3 through mapping.
What is main use of mapplet?
Enlist some properties of sessions.
What is the fact table?