Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  


yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,


Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  


wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,


Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  


How the informatica server increases the session performance through partitioning the source?

1 Answers  


wat are deployement groups in informatica, how it will be used for developers

0 Answers  


explain about unit testing? in real time?

0 Answers   L&T,


how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,


get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,


what is incremental data aggregation?

3 Answers   IBM,


Categories