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

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2171

How to extract sap data using informatica? What is abap? What are idocs?

1253

What is meant by lookup transformation?

1182

What is the different lookup cache(s)?

1131

Have you worked with/created Parameter file

1714

Write the program through which the records can be updated?

1055

Why update strategy and union transformations are active? Explain with examples.

1285

Which version configuration tool used in ur project?

3323

What is the difference between a connected look up and unconnected lookup?

1003

What do you understand by SOA of Informatica?

1043

What is informatica metadata and where is it stored?

1045

Could you explain what is enterprise data warehouse?

1226

According to his methodology what all you need before you build a datawarehouse

1801

What is a transaction control transformation?

1264

Tell me about MD5 functions in informatica

983