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

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  


Explain lookup transformation is active in informatica

0 Answers   Informatica,


Clarify the aggregator change?

0 Answers  


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  


explain different types of modeling.

2 Answers  


what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  


What are the Differences between connected and unconnected lookup?

6 Answers   TCS,


what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,


How to recover the standalone session?

2 Answers  


What is data transformation manager process?

0 Answers  


how can import the data from the flat files?

2 Answers  


What is a code page?

0 Answers  


Categories