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 / ankit kansal

Use a Rank Transformation and calculate rank on the group by basis on price and then using any router route your data to two different outputs.


http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many number of sessions can one group in batches?

703


What is the meaning of up gradation of repository?

1400


Under which circumstances, informatica server creates reject files?

601


Whats there in global repository

1276


What are junk dimensions?

641






What is expression transformation?

641


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1863


Explain pushdown optimization and types in informatica

676


What do think which one is the better joiner or look up?

738


What are the different ways to implement parallel processing in informatica?

869


What are multi-group transformations?

573


How to do unit testing in informatica? How to load data in informatica ?

658


Explain how many types of dimensions are available in informatica?

602


Which is the t/r that builts only single cache memory?

718


what is INFORMATICA TESTING process

1848