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
- 6677 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
What is pmcmd command?
Why filter transformation is an active one?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is rank index in rank transformation?
What is flashback table ? Advance thanks
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Which files are created during the session rums by informatics server?
Enlist the tasks for which source qualifier transformation is used.
what is index?how it can work in informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
r u done any partitions in ur project?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How can you increase the performance in joiner transformation?
What if the source is a flat-file?
