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
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the code page compatibility?
Explain dynamic target flat file name generation in informatica
What do you mean by worklet?
What are the popular informatica products?
Partition, what happens if the specified key range is shorter and longer
What is an expression transformation?
Define update strategy?
What is InformaticaPowerCenter?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How many types of sessions are there in informatica.please explain them?
What are the guidelines to be followed while using union transformation?
How does a sorter cache works?
What is the difference between stop and abort in informatica
What is meant by active and passive transformation?