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

what is degenerated dimension

6 Answers   Cap Gemini,


suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,


What is power play plug in?

2 Answers  


what are presession,postsession success and postsession failure commands ?

1 Answers  


What are the types of maping in Getting Started Wizard?

1 Answers  






Define mapping and session?

0 Answers   Informatica,


Differentiate between Load Manager and DTM?

0 Answers  


what is size of u r database?

0 Answers  


What is the meaning of up gradation of repository?

0 Answers  


Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  


Explain what are the different types of transformation available in informatica.

0 Answers  


how will compare two mappings in two different repository?

2 Answers   TCS, Real Time,






Categories