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 are the new features of informatica 9.x developer?

535


What is Session and Batches?

666


Define pmcmd command?

624


What is a transaction control transformation?

768


Write the different tools in the workflow manager?

575






What are some examples of informatica etl programs?

537


Explain sql transformation in script mode examples in informatica

605


Do you find any difficulty while working with flat files as source and target?

677


How would you join a node to the already existing domain?

683


How can you generate reports in informatica?

581


What is the meaning of decode in informatica?

648


Enlist the tasks for which source qualifier transformation is used.

590


What is the need of etl tools?

613


What is sorter transformation?

585


What is meant by pre and post session shell command?

626