We are using PDI v9. During data load if source data type doesn't match the target data type then PDI inserts a null value and keeps going. It doesn't through an exception / error.
e.g if "Source1" has following data
10test10
11test11
12test12
XXtestx --*** note XX
14test14
15test15
16test16
17test17
and Source1 is mapped to Target1 (oracle table) where first 2 is column1 is number data typeand next 6 are column2 of varchar2. When transformation is run Target1 ahs following data
10test10
11test11
12test12
testx ---***********
14test14
15test15
16test16
17test17
See how XX is replaced with null. We want to catch this exception but PDI seems not to treat it as an exception.
Any help would be appreciated.
Thanks,
Ajay