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
- 2 Answers
- 4676 Views
- AHM, I also Faced
- E-Mail Answers
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 |
can any one explain me about junk dimension
have you developed documents in your project? and what documents we develop in realtime?
Write the unconnected lookup syntax and how to return more than one column.
what are surrogate keys?
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?
what is worklet and what use of worklet and in which situation we can use it?
why we use datawarehouse
Write the program through which the records can be updated?
What is xml source qualifier transformation in informatica?
If we have lookup table in workflow how do you trouble shhot to increase performance?
Name the different lookup cache(s)?
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
Teradata 
