Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6801 Views
- AHM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain pushdown optimization $pushdownconfig parameter - informatica
what is song in infrmatica...?
If informatica has its scheduler why using third party scheduler?
What do think which one is the better joiner or look up?
What is a sequence generator transformation?
Describe data concatenation?
What is meant by LDAP users?
Informatica Checkpoints
can we override a native sql query within informatica? Where do we do it? How do we do it?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
differences between service based and product based?
What are Dimensional table?
How can you generate reports in informatica?
r u done any partitions in ur project?
Where can we find the throughput option in informatica?
