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 / 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 |
Post New Answer View All Answers
what is the difference between informatica6.1 and infomatica7.1
How big was your fact table
What all join we can perform in LOOKUP transformation?
What are the reusable transformations?
EXL informatica Questions
What are the differences between oltp and olap?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is informatica metadata and where is it stored?
What is the maplet?
How to load a Dimension ? and how to load a fact table?
What is the status code in stored procedure transformation?
What is the difference between router and filter?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?