MDM Extension for Snowflake > Predefined MDM Extension for Snowflake assets > Cloud Data Integration assets
  

Cloud Data Integration assets

MDM Extension for Snowflake includes predefined egress jobs and Cloud Data Integration assets. You can use predefined egress jobs to publish master data from MDM SaaS to the staging tables in Snowflake. You can then use predefined Cloud Data Integration taskflows to publish data from the staging tables into the analytical dimension and fact tables in Snowflake.

Batch jobs and taskflow for Customer 360 SaaS and Snowflake integration

Use predefined egress jobs to export master data from Customer 360 SaaS to the staging tables in Snowflake. Use the predefined Cloud Data Integration taskflow to publish data from the staging tables into the analytical dimension and fact tables in Snowflake.
The following table lists the predefined egress jobs and their dependent assets to export master data from Customer 360 SaaS to Snowflake:
Job Name
Taskflow
Mapping Task
Mapping
Description
infa360snflk_customer_egress_org_snflk_outbound_org_stage
infa360snflk_customer_tf_org_snflk_outbound_org_stage
  • - infa360snflk_customer_mt_org_address_snflk_outbound_org_address
  • - infa360snflk_customer_mt_org_alternateName_snflk_outbound_org_alternateName
  • - infa360snflk_customer_mt_org_document_snflk_outbound_org_document
  • - infa360snflk_customer_mt_org_email_snflk_outbound_org_email
  • - infa360snflk_customer_mt_org_financial_snflk_outbound_org_financial
  • - infa360snflk_customer_mt_org_identifier_snflk_outbound_org_identifier
  • - infa360snflk_customer_mt_org_indicator_snflk_outbound_org_indicator
  • - infa360snflk_customer_mt_org_insurance_snflk_outbound_org_insurance
  • - infa360snflk_customer_mt_org_keyexecutive_snflk_outbound_org_keyexecutive
  • - infa360snflk_customer_mt_org_phone_snflk_outbound_org_phone
  • - infa360snflk_customer_mt_org_root_snflk_outbound_org_customer
  • - infa360snflk_customer_mt_org_segment_snflk_outbound_org_segment
  • - infa360snflk_customer_mt_org_socialhandle_snflk_outbound_org_socialhandle
  • - infa360snflk_customer_mt_org_status_snflk_outbound_org_status
  • - infa360snflk_customer_mt_org_stockexchange_snflk_outbound_org_stockexchange
  • - infa360snflk_customer_mt_org_taxdetails_snflk_outbound_org_taxdetails
  • - infa360snflk_customer_m_org_address_snflk_outbound_org_address
  • - infa360snflk_customer_m_org_alternateName_snflk_outbound_org_alternateName
  • - infa360snflk_customer_m_org_document_snflk_outbound_org_document
  • - infa360snflk_customer_m_org_email_snflk_outbound_org_email
  • - infa360snflk_customer_m_org_financial_snflk_outbound_org_financial
  • - infa360snflk_customer_m_org_identifier_snflk_outbound_org_identifier
  • - infa360snflk_customer_m_org_indicator_snflk_outbound_org_indicator
  • - infa360snflk_customer_m_org_insurance_snflk_outbound_org_insurance
  • - infa360snflk_customer_m_org_keyexecutive_snflk_outbound_org_keyexecutive
  • - infa360snflk_customer_m_org_phone_snflk_outbound_org_phone
  • - infa360snflk_customer_m_org_root_snflk_outbound_org_customer
  • - infa360snflk_customer_m_org_segment_snflk_outbound_org_segment
  • - infa360snflk_customer_m_org_socialhandle_snflk_outbound_org_socialhandle
  • - infa360snflk_customer_m_org_status_snflk_outbound_org_status
  • - infa360snflk_customer_m_org_stockexchange_snflk_outbound_org_stockexchange
  • - infa360snflk_customer_m_org_taxdetails_snflk_outbound_org_taxdetails
Exports customer data from Customer 360 SaaS to the staging tables in Snowflake.
infa360snflk_customer_egress_org_xref_snflk_outbound_org_xref_stage
infa360snflk_customer_tf_org_xref_snflk_outbound_org_xref_stage
infa360snflk_customer_mt_org_xref_snflk_outbound_org_xref
infa360snflk_customer_m_org_xref_snflk_outbound_org_xref
Exports customer data from Customer 360 SaaS to the staging tables in Snowflake.
infa360snflk_customer_egress_person_snflk_outbound_person_stage
infa360snflk_customer_tf_person_snflk_outbound_person_stage
  • - infa360snflk_customer_mt_Person_alternateName_snflk_outbound_person_alternateName
  • - infa360snflk_customer_mt_Person_Citizenship_snflk_outbound_Person_Citizenship
  • - infa360snflk_customer_mt_person_demographic_snflk_outbound_person_demographic
  • - infa360snflk_customer_mt_person_document_snflk_outbound_person_document
  • - infa360snflk_customer_mt_Person_email_snflk_outbound_Person_email
  • - infa360snflk_customer_mt_Person_financial_snflk_outbound_Person_financial
  • - infa360snflk_customer_mt_Person_identifier_snflk_outbound_Person_identifier
  • - infa360snflk_customer_mt_person_insurance_snflk_outbound_person_insurance
  • - infa360snflk_customer_mt_person_lifestyle_snflk_outbound_person_lifestyle
  • - infa360snflk_customer_mt_person_loyalty_snflk_outbound_person_loyalty
  • - infa360snflk_customer_mt_Person_phone_snflk_outbound_Person_phone
  • - infa360snflk_customer_mt_Person_professional_snflk_outbound_person_professional
  • - infa360snflk_customer_mt_Person_qualification_snflk_outbound_Person_qualification
  • - infa360snflk_customer_mt_person_root_snflk_outbound_person_customer
  • - infa360snflk_customer_mt_Person_segment_snflk_outbound_person_segment
  • - infa360snflk_customer_mt_person_socialhandel_snflk_outbound_person_socialhandel
  • - infa360snflk_customer_mt_person_specialization_snflk_outbound_person_specialization
  • - infa360snflk_customer_mt_person_status_snflk_outbound_person_status
  • - infa360snflk_customer_mt_person_taxdetails_snflk_outbound_person_taxdetails
  • - infa360snflk_customer_m_Person_address_snflk_outbound_person_address
  • - infa360snflk_customer_m_Person_alternateName_snflk_outbound_person_alternateName
  • - infa360snflk_customer_m_Person_Citizenship_snflk_outbound_Person_Citizenship
  • - infa360snflk_customer_m_person_demographic_snflk_outbound_person_demographic
  • - infa360snflk_customer_m_person_document_snflk_outbound_person_document
  • - infa360snflk_customer_m_Person_email_snflk_outbound_Person_email
  • - infa360snflk_customer_m_Person_financial_snflk_outbound_Person_financial
  • - infa360snflk_customer_m_Person_identifier_snflk_outbound_Person_identifier
  • - infa360snflk_customer_m_person_insurance_snflk_outbound_person_insurance
  • - infa360snflk_customer_m_person_lifestyle_snflk_outbound_person_lifestyle
  • - infa360snflk_customer_m_person_loyalty_snflk_outbound_person_loyalty
  • - infa360snflk_customer_m_Person_phone_snflk_outbound_Person_phone
  • - infa360snflk_customer_m_Person_professional_snflk_outbound_person_professional
  • - infa360snflk_customer_m_Person_qualification_snflk_outbound_Person_qualification
  • - infa360snflk_customer_m_person_root_snflk_outbound_person_customer
  • - infa360snflk_customer_m_Person_segment_snflk_outbound_person_segment
  • - infa360snflk_customer_m_person_socialhandel_snflk_outbound_person_socialhandle
  • - infa360snflk_customer_m_person_specialization_snflk_outbound_person_specialization
  • - infa360snflk_customer_m_person_status_snflk_outbound_person_status
  • - infa360snflk_customer_m_person_taxdetails_snflk_outbound_person_taxdetails
Exports customer data from Customer 360 SaaS to the staging tables in Snowflake.
infa360snflk_customer_egress_snflk_outbound_person_xref_stage
infa360snflk_customer_tf_person_xref_snflk_outbound_person_xref_stage
infa360snflk_customer_mt_person_XREF_snflk_outbound_person_XREF
infa360snflk_customer_m_person_XREF_snflk_outbound_person_XREF
Exports customer data from Customer 360 SaaS to the staging tables in Snowflake.
The following table lists the predefined taskflow, mapping tasks, and mappings to publish customer data from the staging tables into the analytical dimension and fact tables in Snowflake:
Taskflow
Mapping Task
Mapping
Description
infa360snflk_tf_snflk_customer_stage_snflk_retail_analytics
  • - infa360snflk_mt_snflk_person_stage_snflk_tbl_address_dim
  • - infa360snflk_mt_snflk_person_stage_snflk_tbl_email_dim
  • - infa360snflk_mt_snflk_person_stage_snflk_tbl_phone_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_customer_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_customer_dim_expire_merged_records
  • - infa360snflk_m_snflk_person_stage_snflk_tbl_address_dim
  • - infa360snflk_m_snflk_person_stage_snflk_tbl_email_dim
  • - infa360snflk_m_snflk_person_stage_snflk_tbl_phone_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_customer_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_customer_dim_expire_merged_records
Publishes customer data from the Snowflake staging tables into the analytical dimension and fact tables in Snowflake.

Batch jobs and taskflow for Product 360 SaaS and Snowflake integration

Use predefined egress jobs to export master data from Product 360 SaaS to the staging schema in Snowflake. Use the predefined Cloud Data Integration taskflow to publish data from the staging tables into the analytical dimension and fact tables in Snowflake.
The following table lists the predefined egress jobs and their dependent assets to export master data from Product 360 SaaS to Snowflake:
Job Name
Taskflow
Mapping Task
Mapping
Description
  • - infa360snflk_product_egress_category_snflk_outbound_category_stage
  • - infa360snflk_product_egress_item_snflk_outbound_item_stage
  • - infa360snflk_product_egress_item_xref_snflk_outbound_item_xref_stage
  • - infa360snflk_product_egress_snflk_outbound_classification_stageinfa360snflk_product_egress_snflk_outbound_item_relation_stage
  • - infa360snflk_product_tf_category_snflk_outbound_category_stage
  • - infa360snflk_product_tf_classification_snflk_outbound_classification_stage
  • - infa360snflk_product_tf_item_snflk_outbound_item_stage
  • - infa360snflk_product_tf_item_xref_snflk_outbound_item_xref_stage
  • - infa360snflk_product_tf_relation_item_category_snflk_outbound_item_relation_stage
  • - infa360snflk_product_mt_category_description_snflk_outbound_category_description
  • - infa360snflk_product_mt_category_keywords_snflk_outbound_category_keywords
  • - infa360snflk_product_mt_category_root_snflk_outbound_category_root
  • - infa360snflk_product_mt_classification_snflk_outbound_classification
  • - infa360snflk_product_mt_item_description_snflk_outbound_item_description
  • - infa360snflk_product_mt_item_keyword_snflk_outbound_item_keyword
  • - infa360snflk_product_mt_item_metainfo_snflk_outbound_item_metainfo
  • - infa360snflk_product_mt_item_productHighlight_snflk_outbound_item_productHighlight
  • - infa360snflk_product_mt_item_root_snflk_outbound_item_root
  • - infa360snflk_product_mt_item_selPrice_snflk_outbound_item_selPrice
  • - infa360snflk_product_mt_item_tags_snflk_outbound_item_tags
  • - infa360snflk_product_mt_item_xref_snflk_outbound_item_xref
  • - infa360snflk_product_mt_relation_category_to_category_snflk_outbound_informatica_item_category_relations
  • - infa360snflk_product_mt_relation_item_to_category_outbound_informatica_item_category_relationship_stg
  • - infa360snflk_product_m_item_xref_snflk_outbound_item_xref
  • - infa360snflk_product_m_category_description_snflk_outbound_category_description
  • - infa360snflk_product_m_category_keywords_snflk_outbound_category_keywords
  • - infa360snflk_product_m_category_root_snflk_outbound_category_root
  • - infa360snflk_product_m_classification_snflk_outbound_classification
  • - infa360snflk_product_m_item_description_snflk_outbound_item_description
  • - infa360snflk_product_m_item_keyword_snflk_outbound_item_keyword
  • - infa360snflk_product_m_item_metainfo_snflk_outbound_item_metainfo
  • - infa360snflk_product_m_item_productHighlight_snflk_outbound_item_productHighlight
  • - infa360snflk_product_m_item_root_snflk_outbound_item_root
  • - infa360snflk_product_m_item_selPrice_snflk_outbound_item_selPrice
  • - infa360snflk_product_m_item_tags_snflk_outbound_item_tags
  • - infa360snflk_product_m_relation_category_to_category_outbound_informatica_item_category_relations
  • - infa360snflk_product_m_relation_item_to_category_outbound_informatica_item_category_relationship_stg
Exports product data from Product 360 SaaS to Snowflake.
The following table lists the predefined taskflow, mapping tasks, and mappings to publish product data from the staging tables into the analytical dimension and fact tables in Snowflake:
Taskflow
Mapping Task
Mapping
Description
infa360snflk_tf_snflk_item_stage_snflk_retail_analytics
  • - infa360snflk_mt_snflk_stage_snflk_tbl_item_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_item_dim_expire_merged_records
  • - infa360snflk_mt_snflk_person_stage_snflk_tbl_address_dim
  • - infa360snflk_mt_snflk_person_stage_snflk_tbl_email_dim
  • - infa360snflk_mt_snflk_person_stage_snflk_tbl_phone_dim
  • - infa360snflk_m_snflk_person_stage_snflk_tbl_address_dim
  • - infa360snflk_m_snflk_person_stage_snflk_tbl_email_dim
  • - infa360snflk_m_snflk_person_stage_snflk_tbl_phone_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_item_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_item_dim_expire_merged_records
Publishes product data from the Snowflake staging tables to the analytical dimension and fact tables in Snowflake.

Batch jobs and taskflows for Supplier 360 SaaS and Snowflake integration

Use predefined egress jobs to export master data from Supplier 360 SaaS to the staging schema in Snowflake. Use predefined Cloud Data Integration taskflows to publish data from the staging tables into the analytical dimension and fact tables in Snowflake.
The following table lists the predefined egress jobs and their dependent assets to export master data from Supplier 360 SaaS to Snowflake:
Job Name
Taskflow
Mapping Task
Mapping
Description
infa360snflk_supplier_egress_contact_snflk_outbound_contact_stage
infa360snflk_supplier_tf_contact_snflk_outbound_contact_stage
  • - infa360snflk_supplier_mt_contact_address_snflk_outbound_contact_email
  • - infa360snflk_supplier_mt_contact_identifir_snflk_outbound_contact_identifier
  • - infa360snflk_supplier_mt_contact_phone_snflk_outbound_contact_phone
  • - infa360snflk_supplier_mt_contact_postal_address_snflk_outbound_contact_postal_address
  • - infa360snflk_supplier_mt_contact_root_snflk_outbound_contact_root
  • - infa360snflk_supplier_mt_contact_socialmedia_snflk_outbound_contact_socialmedia
  • - infa360snflk_supplier_mt_contact_status_snflk_outbound_contact_status
  • - infa360snflk_supplier_m_contact_address_snflk_outbound_contact_email
  • - infa360snflk_supplier_m_contact_identifir_snflk_outbound_contact_identifier
  • - infa360snflk_supplier_m_contact_phone_snflk_outbound_contact_phone
  • - infa360snflk_supplier_m_contact_postal_address_snflk_outbound_contact_postal_address
  • - infa360snflk_supplier_m_contact_root_snflk_outbound_contact_root
  • - infa360snflk_supplier_m_contact_socialmedia_snflk_outbound_contact_socialmedia
  • - infa360snflk_supplier_m_contact_status_snflk_outbound_contact_status
Exports supplier data from Supplier 360 SaaS to Snowflake.
infa360snflk_supplier_egress_snflk_outbound_contact_xref_stage
infa360snflk_supplier_tf_contact_xref_snflk_outbound_contact_xref
infa360snflk_supplier_mt_contact_xref_snflk_outbound_contact_xref
infa360snflk_supplier_m_contact_xref_snflk_outbound_contact_xref
Exports supplier data from Supplier 360 SaaS to Snowflake.
infa360snflk_supplier_egress_supplier_snflk_outbound_supplier_stage
infa360snflk_supplier_tf_supplier_snflk_outbound_supplier_stage
  • - infa360snflk_supplier_mt_supplier_address_snflk_outbound_supplier_address
  • - infa360snflk_supplier_mt_supplier_alerts_snflk_outbound_supplier_alerts
  • - infa360snflk_supplier_mt_supplier_altName_snflk_outbound_supplier_altName
  • - infa360snflk_supplier_mt_supplier_bankdetails_snflk_outbound_supplier_bankdetails
  • - infa360snflk_supplier_mt_supplier_contract_snflk_outbound_supplier_contract
  • - infa360snflk_supplier_mt_supplier_diversity_snflk_outbound_supplier_diversity
  • - infa360snflk_supplier_mt_supplier_document_snflk_outbound_supplier_document
  • - infa360snflk_supplier_mt_supplier_email_snflk_outbound_supplier_email
  • - infa360snflk_supplier_mt_supplier_esg_environmental_reason_snflk_outbound_esg_environmental_reason
  • - infa360snflk_supplier_mt_supplier_esg_governance_reason_snflk_outbound_supplier_gover_reason
  • - infa360snflk_supplier_mt_supplier_esg_rating_sustainalytics_snflk_outbound_supplier_rating
  • - infa360snflk_supplier_mt_supplier_esg_ratingdnb_snflk_outbound_supplier_esg_ratingdnb
  • - infa360snflk_supplier_mt_supplier_esg_social_reason_snflk_outbound_supplier_esg_social_reason
  • - infa360snflk_supplier_mt_supplier_esg_sustain_classification_snflk_outbound_esg_sustain_classification
  • - infa360snflk_supplier_mt_supplier_executiveMembers_snflk_outbound_supplier_executiveMembers
  • - infa360snflk_supplier_mt_supplier_financial_snflk_outbound_supplier_financial
  • - infa360snflk_supplier_mt_supplier_identifier_snflk_outbound_supplier_identifier
  • - infa360snflk_supplier_mt_supplier_insurance_snflk_outbound_supplier_insurance
  • - infa360snflk_supplier_mt_supplier_phone_snflk_outbound_supplier_phone
  • - infa360snflk_supplier_mt_supplier_reference_snflk_outbound_supplier_reference
  • - infa360snflk_supplier_mt_supplier_risk_question_snflk_outbound_supplier_risk_question
  • - infa360snflk_supplier_mt_supplier_root_snflk_outbound_supplier_root
  • - infa360snflk_supplier_mt_supplier_segment_snflk_outbound_supplier_segment
  • - infa360snflk_supplier_mt_supplier_socialMedia_snflk_outbound_supplier_socialMedia
  • - infa360snflk_supplier_mt_supplier_sourcing_manager_snflk_outbound_supplier_sourcing_manager
  • - infa360snflk_supplier_mt_supplier_stock_stg_snflk_outbound_supplier_stock
  • - infa360snflk_supplier_mt_supplier_tax_snflk_outbound_supplier_tax
  • - infa360snflk_supplier_m_supplier_address_snflk_outbound_supplier_address
  • - infa360snflk_supplier_m_supplier_alerts_snflk_outbound_supplier_alerts
  • - infa360snflk_supplier_m_supplier_altName_snflk_outbound_supplier_altName
  • - infa360snflk_supplier_m_supplier_bankdetails_snflk_outbound_supplier_bankdetails
  • - infa360snflk_supplier_m_supplier_contract_snflk_outbound_supplier_contract
  • - infa360snflk_supplier_m_supplier_diversity_snflk_outbound_supplier_diversity
  • - infa360snflk_supplier_m_supplier_document_snflk_outbound_supplier_document
  • - infa360snflk_supplier_m_supplier_email_snflk_outbound_supplier_email
  • - infa360snflk_supplier_m_supplier_esg_environmental_reason_snflk_outbound_esg_environmental_reason
  • - infa360snflk_supplier_m_supplier_esg_governance_reason_snflk_outbound_supplier_gover_reason
  • - infa360snflk_supplier_m_supplier_esg_rating_sustainalytics_snflk_outbound_supplier_rating
  • - infa360snflk_supplier_m_supplier_esg_ratingdnb_snflk_outbound_supplier_esg_ratingdnb
  • - infa360snflk_supplier_m_supplier_esg_social_reason_snflk_outbound_supplier_esg_social_reason
  • - infa360snflk_supplier_m_supplier_esg_sustain_classification_snfl_outbound_esg_sustain_classification
  • - infa360snflk_supplier_m_supplier_executiveMembers_snflk_outbound_supplier_executiveMembers
  • - infa360snflk_supplier_m_supplier_financial_snflk_outbound_supplier_financial
  • - infa360snflk_supplier_m_supplier_identifier_snflk_outbound_supplier_identifier
  • - infa360snflk_supplier_m_supplier_insurance_snflk_outbound_supplier_insurance
  • - infa360snflk_supplier_m_supplier_phone_snflk_outbound_supplier_phone
  • - infa360snflk_supplier_m_supplier_reference_snflk_outbound_supplier_reference
  • - infa360snflk_supplier_m_supplier_risk_question_snflk_outbound_supplier_risk_question
  • - infa360snflk_supplier_m_supplier_root_snflk_outbound_supplier_root
  • - infa360snflk_supplier_m_supplier_segment_snflk_outbound_supplier_segment
  • - infa360snflk_supplier_m_supplier_socialMedia_snflk_outbound_supplier_socialMedia
  • - infa360snflk_supplier_m_supplier_sourcing_manager_snflk_outbound_supplier_sourcing_manager
  • - infa360snflk_supplier_m_supplier_stock_stg_snflk_outbound_supplier_stock
  • - infa360snflk_supplier_m_supplier_tax_snflk_outbound_supplier_tax
Exports supplier data from Supplier 360 SaaS to Snowflake.
infa360snflk_supplier_egress_snflk_outbound_supplier_xref_stage
infa360snflk_supplier_tf_supplier_xref_snflk_outbound_supplier_xref_stage
infa360snflk_supplier_mt_supplier_xref_snflk_outbound_supplier_xref
infa360snflk_supplier_m_supplier_xref_snflk_outbound_supplier_xref
Exports supplier data from Supplier 360 SaaS to Snowflake.
The following table lists the predefined taskflows, mapping tasks and mappings to publish supplier data from the staging tables into the analytical dimension and fact tables in Snowflake.
Taskflow
Mapping Task
Mapping
Description
  • - infa360snflk_tf_snflk_supplier_stage_snflk_retail_analytics
  • - infa360snflk_tf_snflk_txn_stage_snflk_retail_analytics
  • - infa360snflk_mt_snflk_dim_snflk_tbl_sales_txn_fact
  • - infa360snflk_mt_snflk_dim_snflk_tbl_supplier_order_txn_fact
  • - infa360snflk_mt_snflk_stage_snflk_tbl_esg_score_dnb_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_esg_score_dnb_environmental_reason_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_esg_score_dnb_governance_reason_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_esg_score_dnb_social_reason_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_supplier_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_supplier_dim_expire_merged_records
  • - infa360snflk_mt_snflk_supplier_stage_snflk_tbl_address_dim
  • - infa360snflk_mt_snflk_supplier_stage_snflk_tbl_phone_dim
  • - infa360snflk_mt_snflk_supplier_stage_snflk_tbl_phone_dim
  • - infa360snflk_m_snflk_dim_snflk_tbl_sales_txn_fact
  • - infa360snflk_m_snflk_dim_snflk_tbl_supplier_order_txn_fact
  • - infa360snflk_m_snflk_stage_snflk_tbl_esg_score_dnb_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_esg_score_dnb_environmental_reason_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_esg_score_dnb_governance_reason_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_esg_score_dnb_social_reason_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_supplier_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_supplier_dim_expire_merged_records
  • - infa360snflk_m_snflk_supplier_stage_snflk_tbl_address_dim
  • - infa360snflk_m_snflk_supplier_stage_snflk_tbl_email_dim
  • - infa360snflk_m_snflk_supplier_stage_snflk_tbl_phone_dim
Publishes supplier data from the Snowflake staging tables to the analytical dimension and fact tables in Snowflake .

Batch jobs and taskflow for Multidomain MDM SaaS and Snowflake integration

Use predefined egress jobs to export master data from Multidomain MDM SaaS to the staging schema in Snowflake. Use the predefined Cloud Data Integration taskflow to publish data from the staging tables into the analytical dimension and fact tables in Snowflake.
The following table lists the predefined egress jobs and their dependent assets to export master data from Multidomain MDM SaaS to Snowflake:
Job Name
Taskflow
Mapping Task
Mapping
Description
  • - infa360snflk_egress_multidomain_location_xref_snflk_outbound_location_xref
  • - infa360snflk_egress_multidomain_location_snflk_outbound_location_stage
  • - infa360snflk_location_tf_multidomain_location_xref_snflk_outbound_location_xref
  • - infa360snflk_location_tf_multidomain_location_snflk_outbound_location_stage
  • - infa360snflk_location_mt_location_operatingHours_snflk_outbound_location_operatingHours
  • - infa360snflk_location_mt_location_positions_snflk_outbound_location_positions
  • - infa360snflk_location_mt_location_altName_snflk_outbound_location_altName
  • - infa360snflk_location_mt_location_identifier_snflk_outbound_location_identifier
  • - infa360snflk_location_mt_location_indicator_snflk_outbound__location_indicator
  • - infa360snflk_location_mt_location_phone_snflk_outbound_location_phone
  • - infa360snflk_location_mt_location_email_snflk_outbound_location_email
  • - infa360snflk_location_mt_location_status_snflk_outbound_location_status
  • - infa360snflk_location_mt_location_root_snflk_outbound_location_root
  • - infa360snflk_location_mt_location_operatingHoursException_snflk_outbound_location_operatingHoursException
  • - infa360snflk_location_mt_location_geoloc_snflk_outbound_location_geoloc
  • - infa360snflk_location_mt_location_address_snflk_outbound_location_address
  • - infa360snflk_location_mt_location_coordinates_snflk_outbound_location_coordinates
  • - infa360snflk_location_mt_location_xref_snflk_outbound_location_xref
  • - infa360snflk_location_m_location_identifier_snflk_outbound_location_identifier
  • - infa360snflk_location_m_location_root_snflk_outbound_location_root
  • - infa360snflk_location_m_location_status_snflk_outbound_location_status
  • - infa360snflk_location_m_location_operatingHours_snflk_outbound_location_operatingHours
  • - infa360snflk_location_m_location_altName_snflk_outbound_location_altName
  • - infa360snflk_location_m_location_indicator_snflk_outbound__location_indicator
  • - infa360snflk_location_m_location_coordinates_snflk_outbound_location_coordinates
  • - infa360snflk_location_m_location_address_snflk_outbound_location_address
  • - infa360snflk_location_m_location_operatingHoursException_outbound_location_operatingHoursException
  • - infa360snflk_location_m_location_positions_snflk_outbound_location_positions
  • - infa360snflk_location_m_location_phone_snflk_outbound_location_phone
  • - infa360snflk_location_m_location_email_snflk_outbound_location_email
  • - infa360snflk_location_m_location_geoloc_snflk_outbound_location_geoloc
  • - infa360snflk_location_m_location_xref_snflk_outbound_location_xref
Exports location data from Multidomain MDM SaaS to Snowflake.
The following table lists the predefined taskflow, mapping tasks, and mappings to publish location data from the staging tables into the analytical dimension and fact tables in Snowflake:
Taskflow
Mapping Task
Mapping
Description
infa360snflk_tf_snflk_location_stage_snflk_retail_analytics
  • - infa360snflk_mt_snflk_location_stage_snflk_tbl_address_dim
  • - infa360snflk_mt_snflk_location_stage_snflk_tbl_email_dim
  • - infa360snflk_mt_snflk_location_stage_snflk_tbl_phone_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_location_dim
  • - infa360snflk_mt_snflk_stage_snflk_tbl_location_dim_expire_merged_records
  • - infa360snflk_m_snflk_location_stage_snflk_tbl_address_dim
  • - infa360snflk_m_snflk_location_stage_snflk_tbl_email_dim
  • - infa360snflk_m_snflk_location_stage_snflk_tbl_phone_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_location_dim
  • - infa360snflk_m_snflk_stage_snflk_tbl_location_dim_expire_merged_records
Publishes location data from the Snowflake staging tables to the analytical dimension and fact tables in Snowflake.