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
What are the settings that you use to configure the joiner transformation?
What are the uses of etl tools?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Differentiate between joiner and lookup transformation?
Write the program through which the records can be updated?
What is confirmed fact in dataware housing?
Write the prerequisite tasks to achieve the session partition?
What is aggregate cache in aggregator transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
is it possible to index the data in cache of lkp transformation ?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is joiner transformation in informatica?
What is an unconnected transformation?
Where do we use mapping variables in informatica?