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 / 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
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is a joiner transformation?
Clarify the utilization of aggregator cache record?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is sequence generator transformation in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
What is a mapplet/worklet in informatica?
What are the settings that you use to configure the joiner transformation?
How do you load first and last records into target table?
what is size of u r database?
How to generate sequence numbers?
Slowly changing dimensions, types and where will you use them
Partition, what happens if the specified key range is shorter and longer
Where is metadata stored?
What is the difference between stop and abort in informatica