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

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7064


what are factless facts? And in which scenario will you use such kinds of fact tables.

1808


What is a code page?

1177


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2340


What is informatica metadata and where is it stored?

991


What is complex mapping?

1120


What is primary and backup node?

1127


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2357


Explain your project of banking domian.

1652


Tell me about MD5 functions in informatica

929


How to update a particular record in target with out running whole workflow?

1576


What do you mean by blocking transformation?

1040


how to load rows into fact table in data warehouse

1190


Explain the pipeline partition with real time example?

1144


How to load last n records of file into target table - informatica

1081