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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we store previous session logs?

988


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

981


what is mean by complex business rule ?

2106


what is the size of u r source(like file or table)?

2196


Define Pmrep command?

992


What are the components of Informatica? And what is the purpose of each?

980


Explain in detail about scd type 1 through mapping.

1295


What is lookup transformation?

1001


What is a passive transformation?

1034


what are factless facts? And in which scenario will you use such kinds of fact tables.

1736


What is mapplet in informatica?

977


What is the difference between informatica 7.0 and 8.0?

951


What is main use of mapplet?

1065


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1994


Why is sorter an active transformation?

1055