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 source data like this
col1 col2 col3
5 3 8
6 2 9
7 1 10
and i want to get target as
col1 col2 col3
5 1 8
6 2 9
7 3 10
which transformation i have to use and how?

Answer Posted / rahul

use sorter trans

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 the use of an aggregator cache file?

1144


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

1067


What could be the possible resons of locks by user?

1036


COM components can be used in Informatica

2315


What is decode in informatica?

1074


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

1424


What is workflow monitor?

1000


What is the use of transformation?

947


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1853


What is target load order?

1190


What is the need of an ETL tool?

1029


What is the way to execute pl/sql script using informatica mapping?

1510


Can we create multiple integration service on single repository?

1134


What is data caches/ index caches?

1024


What is the session task and command task?

994