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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / vidyasagar

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are batches?

1108

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1592

What are the conditions needed to improve the performance of informatica aggregator transformation?

1105

Design a mapping to load the cumulative sum of salaries of employees into target table?

1513

What do you mean by blocking transformation?

1054

What are some examples of informatica etl programs?

953

Write the unconnected lookup syntax and how to return more than one column.

1120

Under which circumstances, informatica server creates reject files?

1107

What are data-driven sessions?

1229

Differentiate between a database and data warehouse?

1155

How to call shell scripts from informatica?

1002

What are the different versions of informatica?

1283

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2868

Differentiate between a repository server and a powerhouse?

1129

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2048