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

can any one explain me about junk dimension

4 Answers  


have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,


Write the unconnected lookup syntax and how to return more than one column.

0 Answers  


what are surrogate keys?

5 Answers  


Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

2 Answers   TCS, Deloitte,






what is worklet and what use of worklet and in which situation we can use it?

4 Answers   TCS, Patni,


why we use datawarehouse

0 Answers   HCL,


Write the program through which the records can be updated?

0 Answers  


What is xml source qualifier transformation in informatica?

0 Answers  


If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  


Name the different lookup cache(s)?

0 Answers  


Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,






Categories