Interested to Buy Any Domain ? << Click Here >> for more details...
How to write a procedure for a date which is in three
different formats,and you want to load into datawarehouse in
any single date formate
- 2 Answers
- 6691 Views
- AHM, I also Faced
- E-Mail Answers
Answer Posted / vaibhav bhandeo
Use to_date function in an expression. This will allow you
to change any date's format into other one.
Ex:
to_date('070903', 'yyyy/mm/dd') would return a date value
of 2003/07/09.
to_date('20020315', 'yyyy/mm/dd') would return a date value
of 2003/07/09.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
can we override a native sql query within informatica? How do we do it?
Target increases every day even though no new record was inserted
How we can use union transformation?
what is the complex transformation you used in informatica
How an expression transformation differs from aggregator transformation?
Partition, what happens if the specified key range is shorter and longer
What is the meaning of decode in informatica?
How can we create index after completion of load process?
Enlist few areas or real-time situations where informatica is required.
What is a grid in Informatica?
Is it possible to create multiple domains on a single Informatica server?
What are the differences between a connected lookup and unconnected lookup?
How can we use mapping variables in informatica? Where do we use them?
How to use pmcmd utility command?
