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
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a code page?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is informatica metadata and where is it stored?
What is complex mapping?
What is primary and backup node?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain your project of banking domian.
Tell me about MD5 functions in informatica
How to update a particular record in target with out running whole workflow?
What do you mean by blocking transformation?
how to load rows into fact table in data warehouse
Explain the pipeline partition with real time example?
How to load last n records of file into target table - informatica