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
- 6574 Views
- AHM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
which one is better performance wise joiner or look up
what is informatica metadata?
How many dimensions are there in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain the mapping variable usage example in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Please let me know how to make encryption and decryption with example?
What are the settings that you use to configure the joiner transformation?
What is the difference between router and filter?
How would you copy the content of one repository to another repository?
What do you mean by filter transformation?
What is the difference between informatics 7x and 8x and what is latest version?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Differences between version 7.x and 8.x.
How you know when to use a static cache and dynamic cache in lookup transformation?
