I have the input file as
col1 col2 col3
3 2 1
7 6 8
I should get the output as
col1 col2 col3
1 2 3
6 7 8 ....What is the logic to get this? Is there any
transformation which sorts row wise ? If not how to sort
the incoming records row wise?

Answer Posted / vishnu

there is no need to use specific transformation to do
this...
Simply connect the ports like.....Col1---
>col3,col2.....>col2 and col3......>col1 then u wil get the
result...any issues let me know

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is stop and abort are same in informatica?

573


Please let me know how to make Data masking in informatica..

1271


Define joiner transformation?

598


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

679


What is the way to execute pl/sql script using informatica mapping?

966






What is repository manager?

538


How can we improve session performance in aggregator transformation?

677


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1700


How do you load alternate records into different tables through mapping flow?

1298


What is the difference between Active and Passive transformation?

637


What happens when a session fails and you click on recover?

659


What is a filter transformation?

573


What are the various types of transformation?

646


What does cheating measurement mean?

600


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1976