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
- 6690 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
In how many ways we can create ports?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain target update override in informatica
What are session parameters ? How do you set them?
What is a joiner transformation and why it is an active one?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
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
Do you find any difficulty while working with flat files as source and target?
Enterprise data warehouse your projects phase by phase explain?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are batches?
What is a grid in Informatica?
How an expression transformation differs from aggregator transformation?
What do you mean by worklet?
What is the format of informatica objects in a repository?
