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 / ankit kansal
You have to use an expression transformation and have two create three variables and output ports and have to write IIF() conditions for all three columns to achieve your desired order.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we store previous session logs?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is mean by complex business rule ?
what is the size of u r source(like file or table)?
Define Pmrep command?
What are the components of Informatica? And what is the purpose of each?
Explain in detail about scd type 1 through mapping.
What is lookup transformation?
What is a passive transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is mapplet in informatica?
What is the difference between informatica 7.0 and 8.0?
What is main use of mapplet?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Why is sorter an active transformation?