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

What is the fact table?

1136


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

2364


What are the guidelines to be followed while using union transformation?

1207


what is unit testing?tell me proceedure

2275


What is a surrogate key?

1154


How to do the error handling of if ur source is flatfiles?

2017


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2058


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1120


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1153


how to load rows into fact table in data warehouse

1229


Slowly changing dimensions, types and where will you use them

1769


What is the difference between STOP and ABORT options in Workflow Monitor?

1311


What is sq transformation?

1230


What all are steps in up gradation of Informatica server?

1094


What are the types of caches in lookup? Explain them.

1012