Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a question about a Compose Task.
I have a mapping that creates a table in the data warehouse from a table in the landing zone. The full load works. Apparently a row with id = 0 and all other values NULL is created. If I now want to run this mapping as a CDC task, I always get the error message “Cannot insert the value NULL into column”. This message occurs when the task “Populating temporary table TTMP_5868_DwhKeys” is to be executed. How can I fix this error, since the NULL line is created by Compose?
Any tips are highly appreciated!
Hello @till_bentz
When we run Full Load or CDC, the 1st row of the HUB table contains id=0 with the remaining columns as NULL.
Kindly check the DDL of the table once.
I would suggest Drop and Recreate the tables once.
Regards,
Suresh