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 / raja
There is no logic for this.You should try to be smart by
asking the useless question.try to ask some question which
will be useful for others.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Is it possible to create multiple domains on a single Informatica server?
What is a transaction control transformation?
Explain sessions?
update strategy transformation in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How an expression transformation differs from aggregator transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What differs when we choose the sorted input for aggregator transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How do you load only null records into target?
Write the program through which the records can be updated?
Explain direct and indirect flat file loading (source file type) - informatica
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
list out all the transformations which use cache?
differences between service based and product based?