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 workflow manager?
What is the sql query overwrite in source qualifier in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
As union transformation gives UNION ALL output, how you will get the UNION output?
Differentiate between router and filter transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is substr in informatica?
What is dimensional table?
What is powercenter on grid?
What are Dimensional table?
Explain transaction control transformation in informatica
What are different types of transformations available in informatica?
Informatica Checkpoints
What is data transformation manager process?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?