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 intricate mapping?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
which one is better performance wise joiner or look up
What are the guidelines to be followed while using union transformation?
What are Dimensional table?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Differentiate between router and filter transformation?
How to load a Dimension ? and how to load a fact table?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is Session and Batches?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Sequence generator, when you move from develoment to production how will you reset
What are multi-group transformations?
How to elaborate tracing level?