I am trying to load data using Cube extract so the following conditions apply
a) All fields have to be defined as key fields.
b) Some of the records in few of the key fields are blank.
So I have tried a statement such as,
"OUTP_UNIT" NVARCHAR(4) not null default '0000',
but I am getting an error as below
[ROLLBACK] - cannot insert NULL or update to NULL: OUTP_UNIT.
What is the workaround for a situation as above.
Thanks for your help.