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
- 6797 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
What does update strategy mean, and what are the different option of it?
Can we get 1st record through Informatica(without sequence number).
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How big was your fact table
How do you load only null records into target? Explain through mapping flow.
Clarify the utilization of aggregator cache record?
What is the reusable transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the new features of informatica 9.x at the developer level?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the tuning lookup transformation - informatica
Can informatica load heterogeneous targets from heterogeneous sources?
What are the types of presistent cache in look up tr.
How can a transformation be made reusable?
What is data movement mode in Informatica and difference between them?
