Data, Analytics & AI Platform

Page tree


Versions Compared

Old Version 19

changes.mady.by.user POLIKINAYUNI-ext, Saikrishna Naidu

Saved on

compared with

New Version 20

changes.mady.by.user POLIKINAYUNI-ext, Saikrishna Naidu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ProjectIDSource TableODS Target Table NameSource ColumnRule'sFinal Target Attribute Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010BFC_GBU
BFC_GBU
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Source_System
Source_System
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Actual_Shipment_Completion_Y_M
Ship_Actual_Shipment_Completion_Y_M
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Actual_shipment_Completion
Ship_Actual_Shipment_Completion
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Order_number
Order_number
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Leg_indicator
Leg_indicator
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Numberif Shipment_Number is "PF1_020/4111623978" then expected is "4111623978"
for example if Shipment_number contains"SF1_020/" then replace it with empty.		Shipment_Number
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Shipping_condit_Keyif contains "PF1_020/" then replace it with emptyShipping_conditions_core_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Shipping_condit_Name
Shipping_conditions_core_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Shipping_Line_Key
Ship_Shipping_Line_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Shipping_Line
Ship_Shipping_Line_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Forward_Agentif contains "PF1_020/" then replace it with emptyForward_Agent_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Forward_Agent_Key
Forward_Agent_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Number_Shipment_Type_Core_Keyif contains "PF1_020/" then replace it with emptyShipment_Type_Core_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Number_Shipment_Type_Core_Name
Shipment_Type_Core_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Number_Shipping_Type_Keyif contains "PF1_020/" then replace it with emptyMain_Shipping_Type_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Number_Shipping_Type_Name
Main_Shipping_Type_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Number_Shipment_Vessel_name_Key
Shipment_Vessel_name_MoT_arrival_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Number_Shipment_Vessel_name_Name
Shipment_Vessel_name_MoT_arrival_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Number_Packaging_materials_Keyif contains "PF1_020/" then replace it with emptyPackaging_materials_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Shipment_Number_Packaging_materials_Medium_Name
Packaging_materials_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Plant_Keyif contains "PF1_020/" then replace it with emptyPlant_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Plant
Plant_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Keyif contains "PF1_020/" then replace it with emptyShip_Departure_Point_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point
Ship_Departure_Point_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Postal_Code_Key
Ship_Departure_Point_Postal_Code_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Location_Key
Ship_Departure_Point_Location
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Country_Key
Ship_Departure_Point_Country_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Country_Name
Ship_Departure_Point_Country_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Transportation_Zone_Key
Ship_Departure_Point_Transportation_Zone_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Transportation_Zone_Name
Ship_Departure_Point_Transportation_Zone_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Region_Key
Ship_Departure_Point_Region_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Departure_Point_Region_Name
Ship_Departure_Point_Region_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Keyif contains "PF1_020/" then replace it with emptyShip_Destination_Point_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi
Ship_Destination_Point_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Postal_Code_Key
Ship_Destination_Point_Postal_Code
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Location_Key
Ship_Destination_Point_Location
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Country_Key
Ship_Destination_Point_Country_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Country_Name
Ship_Destination_Point_Country_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Transportation_Zone_Key
Ship_Destination_Point_Transportation_Zone_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Transportation_Zone_Name
Ship_Destination_Point_Transportation_Zone_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Region_Key
Ship_Destination_Point_Region_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Destination_Poi_Region_Name
Ship_Destination_Point_Region_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Keyif contains "PF1_020/" then replace it with emptyShip_Route_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Medium_Name
Ship_Route_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Transportation_Key
Ship_Transportation_Mode_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Transportation
Ship_Transportation_Mode_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Pre_Shipping_Type_Keyif contains "PF1_020/" then replace it with emptyPre_Shipping_Type_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Pre_Shipping_Type_Name
Pre_Shipping_Type_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Shipping_Type_Keyif contains "PF1_020/" then replace it with emptyShip_Route_Main_Shipping_Type_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Shipping_Type_Name
Ship_Route_Main_Shipping_Type_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Sub_Shipping_Type_Keyif contains "PF1_020/" then replace it with emptySub_Shipping_Type_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Sub_Shipping_Type_Name
Sub_Shipping_Type_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Dep_Node_Point_Keyif contains "PF1_020/" then replace it with emptyDep_Node_Point_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Dep_Node_Point_Medium_Name
Dep_Node_Point_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Dest_Node_Point_Keyif contains "PF1_020/" then replace it with emptyDest_Node_Point_Key
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Ship_Route_Dest_Node_Point_Medium_Name
Dest_Node_Point_Name
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010Gross_W_dels
Gross_W_dels
prj-data-dm-sust-<env>TALEND_PROD_DI_BW_QRY_MVSDTR01_0010ODS_BWH_0000_0000_F1000_F_W_CO_MVSDTR01_0010No_of_Deliveries
No_of_Deliveries

Link: CO2 Emission_Talend_DA&AI TSD_WO0000000761141 - Google Sheets

Link: Scope 3 - CO2 emissions - List of dimensions

Requirements Link:

Widget Connector
urlhttps://docs.google.com/presentation/d/1aDE3YSSLbprgkbkWEmcM-R_gBd9BSIJ_61-wFvTEmD4/edit#slide=id.p

...


Powered by Atlassian Confluence and Brikit Theme Press