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
- 6488 Views
- I also Faced
- E-Mail Answers
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
What are the databases that informatica can connect to windows?
Enlist the tasks for which source qualifier transformation is used.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How many number of sessions can one group in batches?
What are active and passive transformations?
How do you load unique records into one target table and duplicate records into a different target table?
waht type of interface is used for testing the data in informatica
How to extract sap data using informatica?
To import the flat file definition into the designer where should the flat file be placed?
State the differences between sql override and lookup override?
What is status code in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the advantage of informatica?
What is sq transformation?
Where are the source flat files kept before running the session?
