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
- 6575 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
Scheduling properties,whats the default (sequential)
How to use procedural logic inside infromatica?
According to his methodology what all you need before you build a datawarehouse
How to differentiate between the active and passive transformations?
tell me the rules and responsblites in our project(my project is development)
Design time, run time. If you don't create parameter what will happen
In informatica workflow manager, how many repositories can be created?
What are data-driven sessions?
how to load dimension table and fact table. plz tell me the steps.
Can we get 1st record through Informatica(without sequence number).
What are roles and groups and benefits of using them?
Enterprise data warehouse your projects phase by phase explain?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Why update strategy and union transformations are active? Explain with examples.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
