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 the difference between router and filter?

1252

How to elaborate tracing level?

1166

How do you set a varible in incremental aggregation

1879

What differs when we choose the sorted input for aggregator transformation?

1009

What is a passive transformation?

1089

How you know when to use a static cache and dynamic cache in lookup transformation?

1847

What is main use of mapplet?

1125

Why sorter is an active transformation?

1183

Can we change Dynamic to Static or Persistent cache? If so what happens?

2199

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2134

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1071

How to generate or load values in to the target table based on a column value using informatica etl tool.

1058

How many dimensions are there in informatica?

1070

How to extract sap data using informatica? What is abap? What are idocs?

1170

my source is junk data how will u remove that junk data by using unix please any one replay me

3694