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 are the new features of informatica 9.x developer?
What is Session and Batches?
Define pmcmd command?
What is a transaction control transformation?
Write the different tools in the workflow manager?
What are some examples of informatica etl programs?
Explain sql transformation in script mode examples in informatica
Do you find any difficulty while working with flat files as source and target?
How would you join a node to the already existing domain?
How can you generate reports in informatica?
What is the meaning of decode in informatica?
Enlist the tasks for which source qualifier transformation is used.
What is the need of etl tools?
What is sorter transformation?
What is meant by pre and post session shell command?