In this mapping we will understand how to filter the improper Date format data .
To check the Date format , we use IS_DATE() function.
When you take a source as Flatfile , their are chances to see the invalid DATE format .Like as shown in the below source table.
| DATE |
| 20-Apr |
| 11-Mar-2008 |
| 12-Feb-2008 |
| Feb-2008 |
If you look at 1 st and 4th record of above table .It clearly shows that the DATE value format is not correct.In the 1st record year is missing and in the 4th date is missing.In this case it is necessary to see this invalid data to be removed before it loaded into the target .Like as shown in below target table:
-
| DATE |
| 11-Mar-2008 |
| 12-Feb-2008 |
The above can be acheived by using the IS_DATE( ) function .This is declared in Filter Transformation condition.
- The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRUE,FALSE)
