We will be using a very simple sample transformation to test the null value behaviour:We use the Data Grid step to provide some sample data. We specified an id and name column and added data for one record. Let’s run the transformation and take a look at your dimension table in a query client:Notice that Kettle automatically inserted an additional record with a technical key of value 0. This will only happen in the first execution. Below this record...
