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

Answer Posted / pradeep

Use SQL Override and apply the TO_DATE function against the
date columns with the appropriate format mask.

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a filter transformation?

826


How to open an older version of an object in the workspace?

877


What is the maplet?

832


Write the different tools in the workflow manager?

804


Explain the informatica workflow?

834


Briefly define a session task?

829


How many numbers of sessions can one group in batches?

838


Write the advantages of partitioning a session?

1011


How to do unit testing in informatica? How to load data in informatica ?

899


Explain sessions and how many types of sessions are there?

808


what is mean by complex business rule ?

1921


Repository user profiles

1583


Explain constraint based loading in informatica

853


What all join we can perform in LOOKUP transformation?

768


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7952