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

Please let me know how to make Data masking in informatica..

1663

How to go to the older version for a mapping?

1027

What happens when a session fails and you click on recover?

1061

What are the new features of informatica 9.x developer?

899

Explain the types of transformations?

1005

can we override a native sql query within informatica? Where do we do it?

1068

waht type of interface is used for testing the data in informatica

2190

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3811

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2677

What is the surrogate key?

1148

what is size of u r database?

2246

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

982

What is a mapplet/worklet in informatica?

1120

What are different types of transformations available in informatica?

935

Write the different tools in the workflow manager?

993