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 many types of sessions are there in informatica.please explain them?
What is the use of source qualifier?
Differences between connected and unconnected lookup?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the guidelines to be followed while using union transformation?
What is Session and Batches?
Explain what transformation and how many are there in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are different types of transformations available in informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the use of an aggregator cache file?
What is event and what are the tasks related to it?
What is the use of transformation?
Where do we use mapping variables in informatica?
What is meant by active and passive transformation?