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 / arjun
we can take a lkp on source in that we can give cndtion id!=id_in and price=price_in so we can get repeated price in one table
and for the distinct prices we take one aggrtr and in that count on some variable and group by price after that in filter cndtion not isnull(var)= true so that we can distinct values
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to improve the performance of a session using sorter transformation?
What do you understand by a term domain?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to differentiate between the active and passive transformations?
What are the designer tools for creating transformations?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Is stop and abort are same in informatica?
What is an aggregator transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the surrogate key?
what are 3 tech challenges/ common issues you face?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is update strategy transform?
What is dimensional table?
Differentiate between router and filter transformation?