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
- 6006 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
Is it possible to revert a global repository to local one and why?
How to update or delete the rows in a target, which do not have key fields?
How do you use reject loader.
What is target load order?
How we can create indexes after completing the load process?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Mention a few design and development best practices for informatica?
Why update strategy and union transformations are active? Explain with examples.
how to load dimension table and fact table. plz tell me the steps.
Define update strategy?
How to handle decimal places while importing a flatfile into informatica?
What is a mapplet/worklet in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain your project of banking domian.
