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

source is a flat file

empname, empno, sal
ram, 101, 1,000
sam, 102, 2,000

ques: my target needs the data to be loaded as sal -1000 and
2000 excluding commas

target

empname, empno, sal
ram, 101, 1000
sam, 102, 2000

how to implement this?

Question Posted / magnil

Answer Posted / magnil

how would it be possible if value is other than ,000?

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the data movement modes in informatica?

1080

How do you migrate data from one environment to another?

1041

What is the advantage of informatica?

1012

How can we use batches?

961

What is option by which we can run all the sessions in a batch simultaneously?

1078

What is informatica powercenter repository?

1141

Explain what are the different versions of informatica?

1031

What does command task mean?

1062

What is aggregate cache in aggregator transformation?

1061

What is a repository manager?

1029

have u done any performance tuning? how u ll do?

2248

Enlist the differences between database and data warehouse.

1032

Explain the types of lookup transformation?

977

Explain the difference between mapping parameter and mapping variable?

979

What is the meaning of up gradation of repository?

1895