NGBR-00019 – Input Dataset 0 not present in design time information

NGBR-00019 : Input data set 0 not present in design time information. Extended field properties for this field will not be available.

This was a warning that I broke my head over for more than 2 days. This is the scenario.

I had to load 12 Oracle tables from 12 source files. It was a straight forward 1-1 straight move for each source – target mapping. Since each of the 12 jobs would look exactly the same, I decided to use RCP and create a single job and run the job in a loop in a single Master Sequencer; and this is where the NGBR-00019 warning started cropping up. It wasn’t affecting the data in any which way but our strict standards dictated that jobs be warning free.

After a whole lot of tweaking and design changes, I finally landed on the following page

https://www-304.ibm.com/support/docview.wss?uid=swg1JR37908

Seems that it is a known issue and has been marked as a future enhancement. So if you are facing the same problem, then worry not. Just use the message handler utility to filter these warnings. The Message Handler can be found under tools in both the designer as well as the director. Just demote the warning to informational. This is the only work around available if you are using RCP and extracting from a sequential file. Not that you will encounter this warning every time. It seems pretty inconsistent from that standpoint. But just in case.

Feedback Welcome.