there is a product table
prodid prodname price
100 cinthol 10
101 hamam 10
102 neem 20
103 cake 30
in the above table the price of some products are
duplicated and some product prices are distinct we want to
push the duplicated prices to one target and non-duplicated
prices to other target without using expression and
sequence generator transformation
Answer Posted / akash
This requirement can be met by using an aggregator and then
a router.
In the aggregator use grouping on key fields if key
repetition is to be tested. For Ex:
100 cinthol 10
100 dettol 20
If whole record should be duplicated like:
100 cinthol 10
100 cinthol 10
use group by on all fields and take records count for each
group.
In router use condition:
If record count > 1 send records to duplicate target.
Default can be sent to other target.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
where to store informatica rejected data? How to extract the informatica rejected data?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
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 the need for an etl tool?
what is Active lock explain
How many dimensions are there in informatica?
Make a note of the quantity vaults made in informatica?
What is status code in informatica?
What are the different options available for update strategy?
What are data-driven sessions?
Separate from a database, an information bazaar, and an information stockroom?
How do you load only null records into target?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the types of schemas we have in data warehouse.