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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / pavana
we can sort row wise by using expression transformation .
But the logic to sort must be implemented.by having few
variable ports...
Let me know if there is any other way to sort row wise.
Mr Raja
u can be quite if u dont know the answers. At least others
will answer.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / vidyasagar
u can try this:)
src>> Normalizer>> sorter by asc>> Normalizer>> TgT
Regards:
Vidyasagar
| Is This Answer Correct ? | 1 Yes | 4 No |
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
Explain lookup transformation is active in informatica
Clarify the aggregator change?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
explain different types of modeling.
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
What are the Differences between connected and unconnected lookup?
what is worklet and what use of worklet and in which situation we can use it?
How to recover the standalone session?
What is data transformation manager process?
how can import the data from the flat files?
What is a code page?