Cannot insert a NULL value into column error

[asl23]

Hi,

Hope you're well! Need your assistance here..

My pipeline reads from one table (source) and write into another one (target).

I get an error as below 'Cannot insert a NULL value into column sales_id'. i have double checked and i don't have any Nulls in the source table. 

[SpiroTaleski]

@asl23 

I guess you have null values for the unmatched records, so check the records after joining. 

BR,

Spiro Taleski