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
- 4 Answers
- 6226 Views
- I also Faced
- E-Mail Answers
Answer Posted / krish
take AGG t/r and give count on price
and in router count(price)=1 and count(price)>1.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
update strategy transformation in informatica
Informatica settings are available in which file?
Sequence generator, when you move from develoment to production how will you reset
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are data-driven sessions?
What is the format of informatica objects in a repository?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
what is the complex transformation you used in informatica
What do you mean by filter transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the Process to creating lookup transformation in informatica
difference between repository database and repository service?
how tokens will generate?
permutations of mapplet
