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
- 6800 Views
- AHM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ravi
if u can write decode function
decode((true,Is_date(culm_name,MM/DD/YYYY HH:MM:SS AM'),
to_date(clum_name,'MM/DD/YYYY HH:MM:SS ')
sysdate)
u can write multipul date formats in is,to date functions
otherwise it will return sys date
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we change Dynamic to Static or Persistent cache? If so what happens?
what is confirmed fact?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
Without source how to insert record to target?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
How the Informatica Server reads perameter file?
Tell me about MD5 functions in informatica
what is dimension table?
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 ?
What is an active transformation?
what is fact and what types of fact tables is there
what is surrogate id ?
Teradata 
