Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 10463 Views
- I also Faced
- E-Mail Answers
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
How to start a workflow using pmcmd command?
What is meant by pre and post session shell command?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Enlist some properties of sessions.
Is there any way to read the ms excel datas directly into informatica?
Explain lookup transformation in informatica
What is the function of aggregator transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
design of staging area?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the designer tools for creating transformations?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is the difference between informatica6.1 and infomatica7.1
Can we change Dynamic to Static or Persistent cache? If so what happens?
Can we get 1st record through Informatica(without sequence number).
