Batch jobs Use predefined ingress jobs to import the Global Product Classifications (GPC) and Google product category to Product 360 SaaS . You can process the imported data in MDM SaaS . Use predefined egress jobs to export the processed data from MDM SaaS to the Google BigQuery staging store.
Each job uses a taskflow to run a mapping task. Each mapping task includes a mapping that maps source system fields with MDM SaaS business entity fields.
Batch jobs of the Category business entity for Global Product Classification Use predefined ingress jobs to import product category and hierarchy data from Global Product Classification (GPC) to the Category business entity in Product 360 SaaS .
The following table lists the predefined ingress jobs and their related taskflows, mapping tasks, and mappings to import product category data from Global Product Classification:
Job Name
Taskflow
Mapping Task
Mapping
Description
infa360rtl_ingress_gpc_category_inbound
infa360rtl_tf_gpc_category_inbound
- infa360rtl_mt_gpc_category_brick_inbound_description- infa360rtl_mt_gpc_category_brick_inbound_root- infa360rtl_mt_gpc_category_class_inbound_description- infa360rtl_mt_gpc_category_class_inbound_root- infa360rtl_mt_gpc_category_family_inbound_description- infa360rtl_mt_gpc_category_family_inbound_root- infa360rtl_mt_gpc_category_segment_inbound_description- infa360rtl_mt_gpc_category_segment_inbound_root- infa360rtl_m_gpc_category_brick_inbound_description- infa360rtl_m_gpc_category_brick_inbound_root- infa360rtl_m_gpc_category_class_inbound_description- infa360rtl_m_gpc_category_class_inbound_root- infa360rtl_m_gpc_category_family_inbound_description- infa360rtl_m_gpc_category_family_inbound_root- infa360rtl_m_gpc_category_segment_inbound_description- infa360rtl_m_gpc_category_segment_inbound_rootImports product category data from Global Product Classification (GPC) to the Category business entity in Product 360 SaaS .
infa360rtl_ingress_gpc_categorytocategory_hierarchy_inbound
infa360rtl_tf_gpc_categorytocategory_hierarchy_inbound
- infa360rtl_mt_gpc_categorytocategory_hierarchy_class_inbound- infa360rtl_mt_gpc_categorytocategory_hierarchy_family_inbound- infa360rtl_mt_gpc_categorytocategory_hierarchy_segment_inbound- infa360rtl_m_gpc_categorytocategory_hierarchy_class_inbound- infa360rtl_m_gpc_categorytocategory_hierarchy_family_inbound- infa360rtl_m_gpc_categorytocategory_hierarchy_segment_inboundImports product hierarchy data from Global Product Classification (GPC) to the Category business entity in Product 360 SaaS .
Batch jobs of the Category business entity for Google product category Use predefined ingress jobs to import product category data from Google product category to the Category business entity in Product 360 SaaS .
The following table lists the predefined ingress jobs and their related taskflows, mapping tasks, and mappings to import product category data from Google product category:
Job Name
Taskflow
Mapping Task
Mapping
Description
infa360rtl_ingress_googleproductcategory_category_inbound
infa360rtl_tf_googleproductcategory_category_inbound
- infa360rtl_mt_googleproductcategory_category_inbound_level1_description- infa360rtl_mt_googleproductcategory_category_inbound_level1_root- infa360rtl_mt_googleproductcategory_category_inbound_level2_description- infa360rtl_mt_googleproductcategory_category_inbound_level2_root- infa360rtl_mt_googleproductcategory_category_inbound_level3_description- infa360rtl_mt_googleproductcategory_category_inbound_level3_root- infa360rtl_mt_googleproductcategory_category_inbound_level4_description- infa360rtl_mt_googleproductcategory_category_inbound_level4_root- infa360rtl_mt_googleproductcategory_category_inbound_level5_description- infa360rtl_mt_googleproductcategory_category_inbound_level5_root- infa360rtl_mt_googleproductcategory_category_inbound_level6_description- infa360rtl_mt_googleproductcategory_category_inbound_level6_root- infa360rtl_mt_googleproductcategory_category_inbound_level7_description- infa360rtl_mt_googleproductcategory_category_inbound_level7_root- infa360rtl_m_googleproductcategory_category_inbound_level1_description- infa360rtl_m_googleproductcategory_category_inbound_level1_root- infa360rtl_m_googleproductcategory_category_inbound_level2_description- infa360rtl_m_googleproductcategory_category_inbound_level2_root- infa360rtl_m_googleproductcategory_category_inbound_level3_description- infa360rtl_m_googleproductcategory_category_inbound_level3_root- infa360rtl_m_googleproductcategory_category_inbound_level4_description- infa360rtl_m_googleproductcategory_category_inbound_level4_root- infa360rtl_m_googleproductcategory_category_inbound_level5_description- infa360rtl_m_googleproductcategory_category_inbound_level5_root- infa360rtl_m_googleproductcategory_category_inbound_level6_description- infa360rtl_m_googleproductcategory_category_inbound_level6_root- infa360rtl_m_googleproductcategory_category_inbound_level7_description- infa360rtl_m_googleproductcategory_category_inbound_level7_rootImports product category data from Google product category to the Category business entity in Product 360 SaaS .
infa360rtl_ingress_googleproductcategory_hierarchy_inbound
infa360rtl_tf_googleproductcategory_categorytocategory_hierarchy_inbound
- infa360rtl_mt_googleproductcategory_categorytocategory_hierarchy_inbound_level1- infa360rtl_mt_googleproductcategory_categorytocategory_hierarchy_inbound_level2- infa360rtl_mt_googleproductcategory_categorytocategory_hierarchy_inbound_level3- infa360rtl_mt_googleproductcategory_categorytocategory_hierarchy_inbound_level4- infa360rtl_mt_googleproductcategory_categorytocategory_hierarchy_inbound_level5- infa360rtl_mt_googleproductcategory_categorytocategory_hierarchy_inbound_level6- infa360rtl_mt_googleproductcategory_categorytocategory_hierarchy_inbound_level7- infa360rtl_m_googleproductcategory_categorytocategory_hierarchy_inbound_level1- infa360rtl_m_googleproductcategory_categorytocategory_hierarchy_inbound_level2- infa360rtl_m_googleproductcategory_categorytocategory_hierarchy_inbound_level3- infa360rtl_m_googleproductcategory_categorytocategory_hierarchy_inbound_level4- infa360rtl_m_googleproductcategory_categorytocategory_hierarchy_inbound_level5- infa360rtl_m_googleproductcategory_categorytocategory_hierarchy_inbound_level6- infa360rtl_m_googleproductcategory_categorytocategory_hierarchy_inbound_level7Imports product hierarchy data from Google product category to the Category business entity in Product 360 SaaS .
Batch jobs for Customer 360 SaaS and Google BigQuery integration Use predefined egress jobs to export master data from Customer 360 SaaS to Google BigQuery staging store.
The following table lists the predefined egress jobs and their related taskflows, mapping tasks, and mappings to export master data from Customer 360 SaaS to Google BigQuery.
Batch jobs for Product 360 SaaS and Google BigQuery integration Use predefined egress jobs to export master data from Product 360 SaaS to Google BigQuery staging store.
The following table lists the predefined egress jobs and their related taskflows, mapping tasks, and mappings to export master data from Product 360 SaaS to Google BigQuery.
Job Name
Taskflow
Mapping Task
Mapping
Description
- infa360gbq_egress_product_category_InfaRetail_Extension_product_master_stg- infa360gbq_egress_rtl_product_InfaRetail_Extension_product_master_stg- infa360gbq_egress_product_item_InfaRetail_Extension_product_master_stg- infa360gbq_egress_product_itemXref_InfaRetail_Extension_product_master_stg- infa360gbq_egress_product_class_InfaRetail_Extension_product_master_stg- infa360gbq_egress_rtl_product_xref_InfaRetail_Extension_product_master_stg- infa360gbq_egress_product_relation_InfaRetail_Extension_item_category_realationship_stg- infa360gbq_product_tf_rtl_product_xref_gbq_outbound_rtl_product_stage- infa360gbq_product_tf_rtl_product_gbq_outbound_rtl_product_stage- infa360gbq_product_tf_relation_item_category_gbq_outbound_item_relation_stage- infa360gbq_product_tf_item_xref_gbq_outbound_item_xref_stage- infa360gbq_product_tf_item_gbq_outbound_item_stage- infa360gbq_product_tf_classification_gbq_outbound_classification_stage- infa360gbq_product_tf_category_gbq_outbound_category_stage- infa360gbq_product_tf_hierarchy_item_category_gbq_outbound_item_hierarchy_stage- infa360gbq_product_mt_relation_item_to_category_outbound_informatica_item_category_relationship_stg- infa360gbq_product_mt_category_root_gbq_outbound_category_root- infa360gbq_product_mt_item_selPrice_gbq_outbound_item_selPrice- infa360gbq_product_mt_hierarchy_product_to_category_outbound_informatica_item_category_hierarchy_stg- infa360gbq_product_mt_item_root_gbq_outbound_item_root- infa360gbq_product_mt_hierarchy_item_to_category_outbound_informatica_item_category_hierarchy_stg- infa360gbq_product_mt_item_xref_gbq_outbound_item_xref- infa360gbq_product_mt_hierarchy_classification_gbq_outbound_informatica_classification_hierarchy- infa360gbq_product_mt_rtl_product_xref_gbq_outbound_rtl_product_xref- infa360gbq_product_mt_item_metainfo_gbq_outbound_item_metainfo- infa360gbq_product_mt_classification_gbq_outbound_classification- infa360gbq_product_mt_rtl_product_tags_gbq_outbound_rtl_product_tags- infa360gbq_product_mt_rtl_product_root_gbq_outbound_rtl_product_root- infa360gbq_product_mt_item_descripation_gbq_outbound_item_descripation- infa360gbq_product_mt_rtl_product_highlights_gbq_outbound_rtl_product_highlights- infa360gbq_product_mt_item_tags_gbq_outbound_item_tags- infa360gbq_product_mt_category_keywords_gbq_outbound_category_keywords- infa360gbq_product_mt_relation_category_to_category_gbq_outbound_informatica_item_category_relations- infa360gbq_product_mt_item_productHighlight_gbq_outbound_item_productHighlight- infa360gbq_product_mt_hierarchy_category_to_classification_gbq_outbound_item_category_hierarchy- infa360gbq_product_mt_item_keyword_gbq_outbound_item_keyword- infa360gbq_product_mt_category_description_gbq_outbound_category_description- infa360gbq_product_mt_rtl_product_description_gbq_outbound_rtl_product_description- infa360gbq_product_mt_relation_category_to_classification_gbq_outbound_informatica_item_category_rel- infa360gbq_product_mt_rtl_product_price_range_gbq_outbound_rtl_product_price_range- infa360gbq_product_mt_rtl_product_keywords_gbq_outbound_rtl_product_keywords- infa360gbq_product_mt_hierarchy_category_to_category_gbq_outbound_informatica_item_category_hierarchy- infa360gbq_product_m_relation_category_to_category_gbq_outbound_informatica_item_category_relations- infa360gbq_product_m_rtl_product_root_gbq_outbound_rtl_product_root- infa360gbq_product_m_hierarchy_category_to_category_gbq_outbound_informatica_item_category_hierarchy- infa360gbq_product_m_classification_gbq_outbound_classification- infa360gbq_product_m_category_root_gbq_outbound_category_root- infa360gbq_product_m_rtl_product_xref_gbq_outbound_rtl_product_xref- infa360gbq_product_m_item_productHighlight_gbq_outbound_item_productHighlight- infa360gbq_product_m_hierarchy_classification_gbq_outbound_informatica_classification_hierarchy- infa360gbq_product_m_category_keywords_gbq_outbound_category_keywords- infa360gbq_product_m_hierarchy_product_to_category_outbound_informatica_item_category_hierarchy_stg- infa360gbq_product_m_hierarchy_category_to_classification_gbq_outbound_item_category_hierarchy- infa360gbq_product_m_hierarchy_item_to_category_outbound_informatica_item_category_hierarchy_stg- infa360gbq_product_m_item_selPrice_gbq_outbound_item_selPrice- infa360gbq_product_m_item_metainfo_gbq_outbound_item_metainfo- infa360gbq_product_m_rtl_product_keywords_gbq_outbound_rtl_product_keywords- infa360gbq_product_m_relation_item_to_category_outbound_informatica_item_category_relationship_stg- infa360gbq_product_m_item_root_gbq_outbound_item_root- infa360gbq_product_m_rtl_product_price_range_gbq_outbound_rtl_product_price_range- infa360gbq_product_m_rtl_product_highlights_gbq_outbound_rtl_product_highlights- infa360gbq_product_m_category_description_gbq_outbound_category_description- infa360gbq_product_m_rtl_product_description_gbq_outbound_rtl_product_description- infa360gbq_product_m_item_keyword_gbq_outbound_item_keyword- infa360gbq_product_m_item_tags_gbq_outbound_item_tags- infa360gbq_product_m_item_xref_gbq_outbound_item_xref- infa360gbq_product_m_item_descripation_gbq_outbound_item_descripation- infa360gbq_product_m_relation_category_to_classification_gbq_outbound_item_category_relation- infa360gbq_product_m_rtl_product_tags_gbq_outbound_rtl_product_tagsExports master data from Product 360 SaaS to Google BigQuery staging store.
Batch jobs for Supplier 360 SaaS and Google BigQuery integration Use predefined egress jobs to export master data from Supplier 360 SaaS to Google BigQuery staging store.
The following table lists the predefined egress jobs and their related taskflows, mapping tasks, and mappings to export master data from Supplier 360 SaaS to Google BigQuery.
Job Name
Taskflow
Mapping Task
Mapping
Description
- infa360gbq_egress_supplier_InfaRetail_Extension_supplier_master_stg- infa360gbq_egress_supplier_xref_InfaRetail_Extension_supplier_master_stg- infa360gbq_supplier_tf_supplier_xref_gbq_outbound_supplier_xref_stage- infa360gbq_supplier_tf_supplier_gbq_outbound_supplier_stage- infa360gbq_customer_tf_esg_emission_gbq_outbound_esg_emission- infa360gbq_supplier_tf_contact_xref_gbq_outbound_contact_xref_stage- infa360gbq_supplier_tf_contact_gbq_outbound_contact_stage- infa360gbq_supplier_mt_contact_identifir_gbq_outbound_contact_identifir- infa360gbq_supplier_mt_supplier_contract_gbq_outbound_supplier_contract- infa360gbq_supplier_mt_supplier_esg_ratingdnb_gbq_outbound_supplier_esg_ratingdnb- infa360gbq_supplier_mt_contact_root_gbq_outbound_contact_root- infa360gbq_supplier_mt_supplier_socialMedia_gbq_outbound_supplier_socialMedia- infa360gbq_supplier_mt_supplier_sourcing_manager_gbq_outbound_supplier_sourcing_manager- infa360gbq_supplier_mt_supplier_reference_gbq_outbound_supplier_reference- infa360gbq_supplier_mt_supplier_esg_rating_sustainalytics_gbq_outbound_supplier_rating- infa360gbq_supplier_mt_supplier_risk_question_gbq_outbound_supplier_risk_question- infa360gbq_customer_mt_rtl_esg_emission_gbq_outbound_rtl_esg_emission- infa360gbq_supplier_mt_contact_address_gbq_outbound_contact_email- infa360gbq_supplier_mt_supplier_segment_gbq_outbound_supplier_segment- infa360gbq_supplier_mt_supplier_document_gbq_outbound_supplier_document- infa360gbq_supplier_mt_supplier_esg_industry_classification_gbq_outbound_supplier_esg_industry_class- infa360gbq_supplier_mt_supplier_bankdetails_gbq_outbound_supplier_bankdetails- infa360gbq_supplier_mt_supplier_financial_gbq_outbound_supplier_financial- infa360gbq_supplier_mt_supplier_insurance_gbq_outbound_supplier_insurance- infa360gbq_supplier_mt_supplier_altName_gbq_outbound_supplier_altName- infa360gbq_supplier_mt_supplier_esg_social_reason_gbq_outbound_supplier_esg_social_reason- infa360gbq_supplier_mt_supplier_esg_sustain_classification_gbq_outbound_esg_sustain_classification- infa360gbq_supplier_mt_supplier_phone_gbq_outbound_supplier_phone- infa360gbq_supplier_mt_supplier_alerts_gbq_outbound_supplier_alerts- infa360gbq_supplier_mt_contact_postal_address_gbq_outbound_contact_postal_address- infa360gbq_supplier_mt_supplier_diversity_gbq_outbound_supplier_diversity- infa360gbq_supplier_mt_supplier_address_gbq_outbound_supplier_address- infa360gbq_supplier_mt_supplier_root_gbq_outbound_supplier_root- infa360gbq_supplier_mt_supplier_esg_environmental_reason_gbq_outbound_esg_environmental_reason- infa360gbq_supplier_mt_supplier_tax_gbq_outbound_supplier_tax- infa360gbq_supplier_mt_contact_phone_gbq_outbound_contact_phone- infa360gbq_supplier_mt_supplier_executiveMembers_gbq_outbound_supplier_executiveMembers- infa360gbq_supplier_mt_contact_xref_gbq_outbound_contact_xref- infa360gbq_supplier_mt_supplier_xref_gbq_outbound_supplier_xref- infa360gbq_supplier_mt_contact_socialmedia_gbq_outbound_contact_socialmedia- infa360gbq_supplier_mt_supplier_stock_stg_gbq_outbound_supplier_stock- infa360gbq_customer_mt_rtl_esg_activity_data_gbq_outbound_rtl_esg_activity_data- infa360gbq_supplier_mt_contact_status_gbq_outbound_contact_status- infa360gbq_supplier_mt_supplier_identifier_gbq_outbound_supplier_identifier- infa360gbq_supplier_mt_supplier_esg_governance_reason_gbq_outbound_supplier_gover_reason- infa360gbq_supplier_mt_supplier_email_gbq_outbound_supplier_email- infa360gbq_supplier_m_contact_xref_gbq_outbound_contact_xref- infa360gbq_supplier_m_supplier_altName_gbq_outbound_supplier_altName- infa360gbq_supplier_m_contact_postal_address_gbq_outbound_contact_postal_address- infa360gbq_supplier_m_supplier_phone_gbq_outbound_supplier_phone- infa360gbq_supplier_m_supplier_segment_gbq_outbound_supplier_segment- infa360gbq_supplier_m_supplier_esg_industry_classification_gbq_outbound_supplier_esg_industry_class- infa360gbq_supplier_m_supplier_diversity_gbq_outbound_supplier_diversity- infa360gbq_supplier_m_supplier_esg_environmental_reason_gbq_outbound_esg_environmental_reason- infa360gbq_supplier_m_supplier_sourcing_manager_gbq_outbound_supplier_sourcing_manager- infa360gbq_supplier_m_contact_address_gbq_outbound_contact_email- infa360gbq_supplier_m_supplier_contract_gbq_outbound_supplier_contract- infa360gbq_supplier_m_contact_socialmedia_gbq_outbound_contact_socialmedia- infa360gbq_supplier_m_supplier_document_gbq_outbound_supplier_document- infa360gbq_supplier_m_supplier_stock_stg_gbq_outbound_supplier_stock- infa360gbq_supplier_m_supplier_reference_gbq_outbound_supplier_reference- infa360gbq_supplier_m_supplier_esg_ratingdnb_gbq_outbound_supplier_esg_ratingdnb- infa360gbq_supplier_m_contact_identifir_gbq_outbound_contact_identifir- infa360gbq_supplier_m_supplier_socialMedia_gbq_outbound_supplier_socialMedia- infa360gbq_supplier_m_supplier_esg_sustain_classification_gbq_outbound_esg_sustain_classification- infa360gbq_supplier_m_supplier_root_gbq_outbound_supplier_root- infa360gbq_supplier_m_supplier_risk_question_gbq_outbound_supplier_risk_question- infa360gbq_supplier_m_supplier_insurance_gbq_outbound_supplier_insurance- infa360gbq_customer_m_rtl_esg_activity_data_gbq_outbound_rtl_esg_activity_data- infa360gbq_supplier_m_supplier_address_gbq_outbound_supplier_address- infa360gbq_supplier_m_contact_status_gbq_outbound_contact_status- infa360gbq_supplier_m_contact_root_gbq_outbound_contact_root- infa360gbq_supplier_m_supplier_financial_gbq_outbound_supplier_financial- infa360gbq_supplier_m_supplier_executiveMembers_gbq_outbound_supplier_executiveMembers- infa360gbq_customer_m_rtl_esg_emission_gbq_outbound_rtl_esg_emission- infa360gbq_supplier_m_supplier_esg_social_reason_gbq_outbound_supplier_esg_social_reason- infa360gbq_supplier_m_supplier_tax_gbq_outbound_supplier_tax- infa360gbq_supplier_m_supplier_esg_governance_reason_gbq_outbound_supplier_gover_reason- infa360gbq_supplier_m_supplier_bankdetails_gbq_outbound_supplier_bankdetails- infa360gbq_supplier_m_supplier_email_gbq_outbound_supplier_email- infa360gbq_supplier_m_supplier_esg_rating_sustainalytics_gbq_outbound_supplier_rating- infa360gbq_supplier_m_contact_phone_gbq_outbound_contact_phone- infa360gbq_supplier_m_supplier_xref_gbq_outbound_supplier_xref- infa360gbq_supplier_m_supplier_alerts_gbq_outbound_supplier_alerts- infa360gbq_supplier_m_supplier_identifier_gbq_outbound_supplier_identifierExports master data from Supplier 360 SaaS to Google BigQuery staging store.
Batch jobs for Multidomain MDM SaaS and Google BigQuery integration Use predefined egress jobs to export master data from Multidomain MDM SaaS to Google BigQuery staging store.
The following table lists the predefined egress jobs and their related taskflows, mapping tasks, and mappings to export master data from Multidomain MDM SaaS to Google BigQuery.
Job Name
Taskflow
Mapping Task
Mapping
Description
- infa360gbq_egress_locMaster_InfaRetail_Extension_location_master_stg- infa360gbq_egress_locXref_InfaRetail_Extension_location_master_stg- infa360gbq_location_tf_multidomain_location_xref_gbq_outbound_location_xref- infa360gbq_location_tf_multidomain_location_gbq_outbound_location_stage- infa360gbq_location_mt_location_address_gbq_outbound_location_address- infa360gbq_location_mt_location_altName_gbq_outbound_location_altName- infa360gbq_location_mt_location_operatingHours_gbq_outbound_location_operatingHours- infa360gbq_location_mt_location_indicator_gbq_outbound__location_indicator- infa360gbq_location_mt_location_operatingHoursException_gbq_outbound_location_operatingHoursException- infa360gbq_location_mt_location_xref_gbq_outbound_location_xref- infa360gbq_location_mt_location_identifier_gbq_outbound_location_identifier- infa360gbq_location_mt_location_status_gbq_outbound_location_status- infa360gbq_location_mt_location_phone_gbq_outbound_location_phone- infa360gbq_location_mt_location_root_gbq_outbound_location_root- infa360gbq_location_mt_location_email_gbq_outbound_location_email- infa360gbq_location_m_location_operatingHoursException_gbq_outbound_location_operatingHoursException- infa360gbq_location_m_location_operatingHours_gbq_outbound_location_operatingHours- infa360gbq_location_m_location_altName_gbq_outbound_location_altName- infa360gbq_location_m_location_status_gbq_outbound_location_status- infa360gbq_location_m_location_indicator_gbq_outbound__location_indicator- infa360gbq_location_m_location_identifier_gbq_outbound_location_identifier- infa360gbq_location_m_location_xref_gbq_outbound_location_xref- infa360gbq_location_m_location_phone_gbq_outbound_location_phone- infa360gbq_location_m_location_root_gbq_outbound_location_root- infa360gbq_location_m_location_address_gbq_outbound_location_address- infa360gbq_location_m_location_email_gbq_outbound_location_emailExports master data from Multidomain MDM SaaS to Google BigQuery staging store.