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
- 6290 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 |
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to join three sources using joiner?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the Process to creating lookup transformation in informatica
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
What are the different types of olap? Give an example?
what is scd?
What are the restrictions of union transformation?
why do we go for update strategy tr in SCD rather using the session properties?
Teradata 
