1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / pavana

Answers were Sorted based on User's Feedback



I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 ..

Answer / 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

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 ..

Answer / vishnu

there is no need to use specific transformation to do
this...
Simply connect the ports like.....Col1---
>col3,col2.....>col2 and col3......>col1 then u wil get the
result...any issues let me know

Is This Answer Correct ?    5 Yes 4 No

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 ..

Answer / 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

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 ..

Answer / 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

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 ..

Answer / vidyasagar

u can try this:)

src>> Normalizer>> sorter by asc>> Normalizer>> TgT

Regards:
Vidyasagar

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Informatica Interview Questions

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

How to call shell scripts from informatica?

0 Answers  

without update strategy how to insert &update?

1 Answers   DELL,




How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

Explain grouped cross tab?

1 Answers   Accenture,

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

tell me the push down optimization

2 Answers   Wipro,

Differentiate between a database and data warehouse?

0 Answers  

For more Informatica Interview Questions Click Here
Categories