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
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 |
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?
what are the settiings that u use to cofigure the joiner transformation?
Please let me know how to make encryption and decryption with example?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
What is galaxy shema
How can you complete unrcoverable sessions?
What are the circumstances that infromatica server results an unreciverable session?
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?
How can you recover the session in sequential batches?
What is informatica worklet?