When you get any warning like below,
APT_CombinedOperatorController(1),0: Field ‘XXXXX’ from input dataset ‘0’ is NULL. Record dropped.
Then don’t ignore this. Because this will case the job to ignore some records, Means those records will not be processed by any of the following records and you you will not get these records in the output file.
What is the cause of this ?
The important cause of this error is in a row, a field (i.e) a column has a NULL value and hence Datastage consider it as an invalid row and drop this.
How to fix this ?
To get rid of this problem we need to have a null handler just next to the source stage. An easiest way is to keep a transformer next to the source stage (Oracle Stage or any file stage ) from where the job gets the data and in that transformer we need to add NullToEmpty() for the input column. so it has direct mapping like below,
You need to have this for all the column. Otherwise you can write a before/after subroutine to achieve this task but that is tedious. This is the simplest way.
can i have one example to use NullToEmpty() with column. i m bit new to datastage!!