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 use mapping variables in informatica? Where do we use them?

1198


How many dimensions are there in informatica?

1084


What is meant by query override?

1057


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

2271


What is dimensional table? Explain the different dimensions.

1170


can u any challenge your project?

2033


What is status code in informatica?

1017


How can we update a record in the target table without using update strategy?

1144


can u give example for factless fact table

6643


What are the types of caches in lookup? Explain them.

969


Explain joiner transformation in informatica

1124


Separate from a database, an information bazaar, and an information stockroom?

1087


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012


Explain pmcmd command usage in informatica

1128


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280