I am creating a SCD2 flow without using SCD2 components(ex: SCDELT).
My source and target tables are in Snowflake database only.
Attaching my SCD2 flow.
I am trying to just insert the new records from source to target.
When i checked the SK and other column values in tLOGROW, they are all not null.
But while inserting data in Snowflake target, it is giving error as:"
"Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: NULL result in a non-nullable column"
Only SK column has Not Null constraint.
Are there empty strings in the source data? Could you please verify whether you have unchecked the below check box in tDBOutput(Snowflake)?
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.