Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 10465 Views
- I also Faced
- E-Mail Answers
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 to improve the performance of a session using sorter transformation?
What is rank transform?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Which means the first record should come as last record and last record should come as first record and load into the target file?
Which version configuration tool used in ur project?
What is exclusive and normal mode for repository services?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
wat are deployement groups in informatica, how it will be used for developers
How would you join a node to the already existing domain?
What the difference is between a database, a data warehouse and a data mart?
Please let me know how to make Data masking in informatica..
How can we delete duplicate rows from flat files?
Separate from an archive server and a powerhouse?
What do you mean incremental aggregation?
can we override a native sql query within informatica? Where do we do it?
