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
- 5301 Views
- I also Faced
- E-Mail Answers
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
what is the difference between informatica6.1 and infomatica7.1
Explain pushdown optimization and types in informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain the difference between mapping parameter and mapping variable?
which one is better performance wise joiner or look up
What are the different types of transformation available in informatica.
How do you load first and last records into target table?
What is meant by query override?
Why do you use Mapping Parameter and mapping variable?
Explain the different dimensions.
What is mapplet in informatica?
Design time, run time. If you don't create parameter what will happen
Is it possible to revert a global repository to local one and why?
What is a sequence generator transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
