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 intricate mapping?

1304


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1216


which one is better performance wise joiner or look up

1148


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

1200


What are Dimensional table?

1116


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1683


Differentiate between router and filter transformation?

1060


How to load a Dimension ? and how to load a fact table?

1458


How do you manage the Parameter files while migrating your data from one environment to another environment?

1063


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1127


What is Session and Batches?

1147


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2195


Sequence generator, when you move from develoment to production how will you reset

2119


What are multi-group transformations?

1158


How to elaborate tracing level?

1215