In this mapping we will understand how to filter the improper NULLvalue data .
To detect the NULL values in a table , we use IS_NULL( ) function.
- In general , when you take source as flatfile or relational , we find few feilds with NULL values .If you think that in your business process this null data is a invalid data.Then its necessary to filter invalid data.The below table shows ::
-
| NAME |
AGE |
| JOHN |
23 |
| SMITH |
|
| |
34 |
| LUCKY |
24 |
- In the above table their are 4 records but in that two are valid and other two are invalid records because in the 2 nd record AGE value is NULL and in the 3rd record the NAME is a NULL value .So it is essential to filter 2nd and 3rd before loading into the target table.The belove table shows how a target table appears witha valid data
-
| NAME |
AGE |
| JOHN |
23 |
| LUCKY |
24 |
- The 2nd and 3rd records can be filtered by using IS_NULL ( ) functionThis is declared Filter Transformation Condition.
- The function appears like this IIF(NOT ISNULL(NAME) ,TRUE,FALSE)
- FIlter transformation passes only TRUE records to the target and drops the FALSE records which are nothing but NULL value records.
|
