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
Write the unconnected lookup syntax?
Differentiate between router and filter transformation?
what is the difference between informatica6.1 and infomatica7.1
How to open an older version of an object in the workspace?
Differentiate between sessions and batches?
What are junk dimensions?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the fact table?
What is powercenter on grid?
difference between repository database and repository service?
What is a passive transformation?
wat are deployement groups in informatica, how it will be used for developers
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?