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 |
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
Discuss the advantages & Disadvantages of star & snowflake schema?
How the informatica server increases the session performance through partitioning the source?
wat are deployement groups in informatica, how it will be used for developers
explain about unit testing? in real time?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
what is incremental data aggregation?