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
- 6604 Views
- AHM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Define mapping and session?
How can we create index after completion of load process?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
What is the use of incremental aggregation?
How does a sorter cache works?
What is the Difference between SetVariable and setmaxvariable in informatica?
How to prepared lld.can any one tell me detailed explanetion.
what type of transformation is not supported by mapplets?
HOW TO YOU LOAD TIME DIMENSION
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
Teradata 
