I have a table1 with a default value of 'ABCDEF' for my_id .
I use a sql transform statement to place the data into that table from table2.
Insert into table1
In certain cases original_id appears to have a null value.
I've noticed that the default value is NOT being utilized for my_id and my_id has a NULL.
I realize I could use a NVL() to get the default value into the table, but shouldn't the default value be going into the table if the incoming field is null?