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
- 5736 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
Target increases every day even though no new record was inserted
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Under which circumstances, informatica server creates reject files?
How to implement security measures using repository manager?
Where are the source flat files kept before running the session?
Define Pmrep command?
What is lookup change?
What is sorter transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to join three sources using joiner?
What do you mean incremental aggregation?
What is an unconnected transformation?
Explain scd type 3 through mapping.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
