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

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


what are the settiings that u use to cofigure the joiner transformation?

2 Answers  


Please let me know how to make encryption and decryption with example?

0 Answers  


What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,


Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  






What is galaxy shema

2 Answers   CGI,


How can you complete unrcoverable sessions?

1 Answers  


What are the circumstances that infromatica server results an unreciverable session?

1 Answers  


How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,


What is update override?

1 Answers   Accenture,


How can you recover the session in sequential batches?

1 Answers  


What is informatica worklet?

0 Answers  


Categories