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

Answers were Sorted based on User's Feedback



How to write a procedure for a date which is in three different formats,and you want to load into d..

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

How to write a procedure for a date which is in three different formats,and you want to load into d..

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

Post New Answer

More Informatica Interview Questions

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,


When will you use SQL override in a lookup transformation?

1 Answers  


Write the advantages of partitioning a session?

0 Answers  


Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,


How can you complete unrcoverable sessions?

1 Answers  


How an expression transformation differs from aggregator transformation?

0 Answers  


What is the cumulative sum and moving sum?

0 Answers  


Is it possible to create multiple domains on a single Informatica server?

0 Answers  


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


WAT IS TEXT LOAD?

3 Answers   Wipro,


What is Index Caches size?

0 Answers   Informatica,


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


Categories