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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4034


Explain Dataware house architecture .how data flow from intial to end?

2524


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2176


What are the reusable transformations?

1094


What do you mean by blocking transformation?

967


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8124


what is SDLC way of code development?

1966


Explain incremental aggregation in informatica

1060


What is aggregate cache in aggregator transformation?

1057


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10629


what are the Methods For Creating Reusable Transformations?

1096


Can we create a Integration service without a Repository service and vice versa?

1169


What is the difference between writing a joiner query in ANSI style and THETA style?

2319


write a query to retrieve the latest records from the table sorted by version(scd)

996


How to extract sap data using informatica?

981