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
What is the fact table?
have u done any performance tuning? how u ll do?
What are the guidelines to be followed while using union transformation?
what is unit testing?tell me proceedure
What is a surrogate key?
How to do the error handling of if ur source is flatfiles?
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
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
how to load rows into fact table in data warehouse
Slowly changing dimensions, types and where will you use them
What is the difference between STOP and ABORT options in Workflow Monitor?
What is sq transformation?
What all are steps in up gradation of Informatica server?
What are the types of caches in lookup? Explain them.