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
- 41191 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / durgaprasad
data flow for this one is:
sq-->Aggregater-->Router-->target
in aggregater t/r take 2 output ports and give condition like
uniqe_port---->count(*)=1
duplicate_port--->count(*)>1
connect this one router and in router take 2 groups and
give condition like
uniqgroup=uniqe_port
duplicategroup=duplicate_port
and connect that groups to target
| Is This Answer Correct ? | 15 Yes | 28 No |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the differences between joiner transformation and source qualifier transformation?
explain abt ur project architecture?
What is data transformation manager process?
What is sorter transformation?
Differences between version 7.x and 8.x.
How to differentiate between the active and passive transformations?
What do you mean by blocking transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
tell me about your project functionality
What are the uses of etl tools?
How many types of sessions are there in informatica.please explain them?
What is mapplet in informatica?
