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
- 6620 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 expression transformation?
Can we create a Integration service without a Repository service and vice versa?
How will the document be delivered to me?
Is it possible to define a single node as a Gateway node as well as worker node?
tell me the rules and responsblites in our project(my project is development)
what is the hint? how to use it to reduce the query processing in program?
In informatics server which files are created during the session rums?
What does refresh system mean, and what are its distinctive choice?
What are the types of schemas we have in data warehouse and what are the difference between them?
What can we do to improve the performance of informatica aggregator transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the Process to creating lookup transformation in informatica
How can we delete duplicate rows from flat files?
Please let me know how to make encryption and decryption with example?
While migrating the data from one environment to another environment how would you manage the connections?
