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 is sequence generator transformation in informatica?

1060

Define update strategy?

1199

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2134

Explain about cumulative Sum or moving sum?

1023

tell me 5 session failure in real time how can you solve that in your project?

2272

Explain why we use partitioning the session in informatica?

1075

How does a sorter cache works?

1048

what is SDLC way of code development?

2025

What are the new features of informatica 9.x developer?

956

What are the databases that informatica can connect to windows?

1040

Differentiate between Load Manager and DTM?

2145

What is informatica? Why do we need it?

1085

What is the difference between a repository server and a powerhouse?

1492

What is meant by a domain?

1114

Explain the code page compatibility?

1052