How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / ram mohan reddy
we can do this process by 2 ways ....
1)by dynamic lookup option in lookup(new lookup row) we can
load duplicate rows in one target table and unique rows in
one target table
do to this we need to have router transformation (add to
group ports one is for unique(new lookup row=1) and other is
for duplicate(new lookup row =2))after the lookup trans.
2)we can perform this by aggregator transformation using
coutnt(*) >1 for duplicate rows .here also we need to use
router transformion.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Clarify the utilization of aggregator cache record?
What is expression transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to elaborate tracing level?
What are the main features of Oracle 8i with context to datawarehouse?
Informatica settings are available in which file?
Explain pushdown optimization and types in informatica
How many ways are there to create ports?
What is meant by a domain?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the components of workflow manager?
Mention a few design and development best practices for informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a rank transform?
How does the aggregator transformation handle null values?