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
- 41298 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
During the running session, output files are created by informatica server. Enlist few of them.
How many dimensions are there in informatica?
What are mapplets?
Explain the features of connected and unconnected lookup.
How does a sorter cache works?
How can we create index after completion of load process?
Target increases every day even though no new record was inserted
What are the main features of Oracle 8i with context to datawarehouse?
What are the components of Informatica? And what is the purpose of each?
What is the function of aggregator transformation?
What is the difference between a connected look up and unconnected lookup?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain constraint based loading in informatica
What is incremental aggregation?
How can we update a record in the target table without using update strategy?
