IIF(IS_DATE(col1,'dd/mm/yyyy'),to_date(col1,'dd-mm-yyyy),NUL

Three date formats are there . How to change these three into
One format without using expression transformation ?

Question Posted / isha_gtb

Answer Posted / isha_gtb

IIF(IS_DATE(col1,'dd/mm/yyyy'),to_date(col1,'dd-mm-yyyy),NULL)

Is_date to check the format
and to_date to change it to desired format

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is workflow? What are the components of workflow manager?

1133

Explain the different dimensions.

921

What is informatica powercenter repository?

1150

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2315

What is Cognos script editor?

4178

How can we store previous session logs?

1007

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2201

Is it possible to use a client with different version than that of its Informatica server?

1093

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2339

Please let me know how to make encryption and decryption with example?

1870

What is sq transformation?

1097

what are the Methods For Creating Reusable Transformations?

1117

Global and Local shortcuts. Advantages.

1982

What is the use of target designer?

1001

where to store informatica rejected data? How to extract the informatica rejected data?

964