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
- 6326 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
How do you update the records with or without using update strategy?
Can we create two repositories on same database instance in oracle?
What is workflow? What are the components of workflow manager?
Where can we find the throughput option in informatica?
On which transformations you created partitions in your project?
What is an Integration service in Informatica?
How to elaborate powercenter integration service?
draw informatica architecture 8.6 ?
Slowly changing dimensions, types and where will you use them
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain pmcmd command usage in informatica
Write the program through which the records can be updated?
Define filter transformation?
What is meant by lookup transformation?
Which files are created during the session rums by informatics server?
