When you take a source as Flatfile and it consists one of the feild as DATE and its datatype generally a String .The following below table is the source table ::
| Feild Name |
Datatype |
| DATE |
String |
If you want to load the above source data into realtional target.Then it is manditory to match the datatype.In relational generaly the date datatype is Date.The following below table is the target table ::
| Feild Name |
Datatype |
| DATE |
Date |
To match the datatype of ports , we use the TO_DATE ( ) function in expression transformation editor.The function appears like this TO_DATE(DATE,'DD-MON-YY')
