You can use egress jobs to publish master data from MDM SaaS to the staging tables in Snowflake. Use Cloud Data Integration taskflows to publish data from the staging tables in Snowflake into the analytical dimension and fact tables in Snowflake.
The following image shows the flow of data from MDM SaaS to Snowflake:
When you run MDM SaaS egress jobs, Cloud Data Integration assets export MDM SaaS master data, such as customer, product, supplier, and location master data, into the staging tables in Snowflake.
When you run Cloud Data Integration taskflows, Cloud Data Integration transforms and publishes data from the staging tables in Snowflake into the analytical dimension and fact tables in Snowflake.
