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

Enlist few areas or real-time situations where informatica is required.

1088

Different sorts of metadata that stores in the storage facility?

1014

Explain dynamic target flat file name generation in informatica

1055

How can we delete duplicate rows from flat files?

1225

Explain scd type 3 through mapping.

1021

What is a code page?

1181

What is an active transformation?

1113

What are Dimensional table?

1060

What is the procedure for creating independent data marts from informatica 7.1?

1067

What is a filter transformation?

1048

What is the Process to creating lookup transformation in informatica

1046

What is repository manager?

990

Mention some types of transformation?

1048

What are batches?

1102

Is it possible to revert a global repository to local one and why?

1083