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

Explain the shared cache and re-cache?

0 Answers  

How you count the number of records available at your source?

3 Answers   Zensar,

How can you generate reports in informatica?

0 Answers  

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

What is predefined event?

1 Answers  




differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

What is target designer and target load order?

0 Answers  

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

What is domain in terms of informatica?

0 Answers  

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  

For more Informatica Interview Questions Click Here
Categories