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

Can we change Dynamic to Static or Persistent cache? If so what happens?

2215


Explain the code page compatibility?

1075


Explain dynamic target flat file name generation in informatica

1063


What do you mean by worklet?

1076


What are the popular informatica products?

1016


Partition, what happens if the specified key range is shorter and longer

2502


What is an expression transformation?

1024


Define update strategy?

1235


What is InformaticaPowerCenter?

1139


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7259


How many types of sessions are there in informatica.please explain them?

1171


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

1146


How does a sorter cache works?

1075


What is the difference between stop and abort in informatica

1100


What is meant by active and passive transformation?

1131