Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 6486 Views
- I also Faced
- E-Mail Answers
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
What is an aggregator transformation?
What are the differences between oltp and olap?
Explain sessions. Explain how batches are used to combine executions?
What do you mean by filter transformation?
What are the different clients of powercenter?
What is a mapplet/worklet in informatica?
What is lookup transformation?
What is substr in informatica?
How to use procedural logic inside infromatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
tell me about your project functionality
What are the limitations of joiner transformation?
Define Pmrep command?
What is workflow monitor?
Mention few advantages of router transformation over filter transformation.
