Integration HUB ETL

[Mark Wood]

Hello Experts,

I am attempting to import data into my target table using Integration Hub ETL. However, in my staging table, I do not have values for some mandatory fields required by the target table. Despite this, I want to proceed with the data insertion without providing values for these required fields.

How can I achieve this in Integration Hub ETL?

Thank you.

[Mani A]

provide default values to mandatory fields or skip the process if those values required for ETL