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
What is union transformation in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
What are the restrictions of union transformation?
Define filter transformation?
What are the types of caches in lookup?
Explain pushdown optimization and types in informatica
What is the command used to run a batch?
According to his methodology what all you need before you build a datawarehouse
What is source qualifier transformation in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the difference between a repository server and a powerhouse?
What are the new features of informatica 9.x developer?
What is decode in informatica?
What are the components of the workflow manager?
can we override a native sql query within informatica? How do we do it?