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 Flat file like the data, sal have 10,000. I want to
load the data in the same format as sal as 10,000. Can
anybody know the answer means please mail me.
Thanks in advance.. My mail id is chandranmca2007@gmail.com

Answer Posted / davankumar

to_char(10000,'99,999.00') from dual;

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about Informatica server process that how it works relates to mapping variables?

1006


How do you take back up of repository?

1094


What are the main issues while working with flat files as source and as targets ?

1095


How to update or delete the rows in a target, which do not have key fields?

1115


What is meant by incremental aggregation?

1020


How an expression transformation differs from aggregator transformation?

988


What are the various types of transformation?

1093


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1950


How identifying bottlenecks in various components of informatica and resolving them?

1054


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2253


Explain about cumulative Sum or moving sum?

975


Explain Dataware house architecture .how data flow from intial to end?

2525


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

2097


What is meant by LDAP users?

1111


Did u used latest transformations of 8.6.0? for what?

1823