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 |
Which kind of index is preferred in DWH?
What is a standalone command task?
Can you access a repository created in previous version of Informatica?
what is the flow?
Explain sessions. Explain how batches are used to combine executions?
can we see default group,when we use router?if yes how?
How can we eliminate duplicate rows from flatfile,explain?
Which is better performance wise database or file?How?
Explain the code page compatibility?
what is Partitioning ? where we can use Partition?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
Difference between session variables and workflow variables?