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
- 10288 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 create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How does a sorter cache works?
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?
Explain the use of aggregator cache file?
Explain the mapping variable usage example in informatica
What are the different components of powercenter?
What is mapping debugger?
Explain sessions?
what is song in infrmatica...?
What are the tasks that can be performed using sq?
differences between service based and product based?
What is the sql query overwrite in source qualifier in informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
How identifying bottlenecks in various components of informatica and resolving them?
pmscmd startworkflow -sv
