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

Answers were Sorted based on User's Feedback



How to write a procedure for a date which is in three different formats,and you want to load into d..

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

How to write a procedure for a date which is in three different formats,and you want to load into d..

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

Post New Answer

More Informatica Interview Questions

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,


How to join three sources using joiner?

0 Answers  


how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


What is the Process to creating lookup transformation in informatica

0 Answers   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.

1 Answers   IBM,


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?

8 Answers   HeadStrong, TCS,


Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  


What are the different types of olap? Give an example?

0 Answers  


what is scd?

6 Answers  


What are the restrictions of union transformation?

0 Answers  


why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,


Categories