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
- 6603 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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is a joiner transformation?
Name the different lookup cache(s)?
How to Create a folder using pmrep command?
Which is the t/r that builts only single cache memory?
Can we override a native sql query within informatica?
what is the size of u r source(like file or table)?
Is it possible to create multiple domains on a single Informatica server?
Explain direct and indirect flat file loading (source file type) - informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
what is mean by complex business rule ?
What is the use of source qualifier?
Can u generate reports in Informatica?
What is native users?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
