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
- 6792 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
Describe an informatica powercenter?
What is persistent lookup cache?
Explain what are the different versions of informatica?
wat are deployement groups in informatica, how it will be used for developers
How can informatica be used for an organization?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain informatica architecture - version 8 / 9
Where can we find the throughput option in informatica?
Performance tuning in UNIX for informatica mappings?
What is the procedure for creating independent data marts from informatica 7.1?
Can we override a native sql query within informatica?
What is InformaticaPowerCenter?
Plz can any one say me how to get the informatica certification materials and dumps
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the difference between informatica 7.0 and 8.0?
