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
- 6325 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
How you know when to use a static cache and dynamic cache in lookup transformation?
wat are deployement groups in informatica, how it will be used for developers
Can we override a native sql query within informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the transformations that are not supported in mapplet?
What are mapplets?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is informatica? Why do we need it?
How we can use union transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
State the differences between sql override and lookup override?
Explain the scenario which compels informatica server to reject files?
Define enterprise data warehousing?
What is a joiner transformation?
