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

source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

Answer Posted / kiran

USE SOTER TR . IN SORTER TR CLICK ON DISTINCT OPTION IT ELIMINATE THE DUPLICATE AS WELL AS SORT THE ORDER.

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is lookup transformation?

1006


Explain your project of banking domian.

1614


What is informatica powercenter repository?

1145


How to implement security measures using repository manager?

1085


What are the different types of repositories created using informatica?

1064


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1011


How can you define user defied event?

980


What is a sequence generator transformation?

956


scenario where i can use only concurrent execution of workflow.

3067


if we have a delimiters at unwanted places in a flat file how can we over come those.

1988


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

993


How an expression transformation differs from aggregator transformation?

993


How to extract sap data using informatica?

989


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1105


What is decode in informatica?

1075