Название пакета: DWH_MDT¶
Описание¶
Загрузка и обработка MDT - управление справочниками и измерениями
Схема¶
Список шагов¶
1. Auto Mapping¶
- Тип: Sequence Container
- Описание: Автоматическое маппирование данных из DS таблиц в OUT таблицы
- Цикличность: Foreach Loop Container (List DS tables)
1.1 Execute usp_MDT_OUT_Load¶
- Тип: Execute SQL Task
- Описание: Загрузка данных из DS таблиц в OUT таблицы с маппингом
- Процедура: etl.usp_MDT_OUT_Load
- Параметры мэппинга данных:
- @Batch → User::Batch
- @MDT_Link_Name → User::MDT_Link_Name
- @MDT_DB_Name → User::MDT_DB_Name
- @TableName_Source → User::TableName_Source
- @TableName_Destination → User::TableName_Destination
- @TableMapping → User::TableMapping
- @TableColumnsExcluded → User::TableColumnsExcluded
- @TableColumnsIncluded → User::TableColumnsIncluded
- @TableColumnsNewMarked → User::TableColumnsNewMarked
Используемые объекты:
| TableName_Source | TableName_Destination | TableMapping | TableColumnsExcluded | TableColumnsIncluded | TableColumnsNewMarked |
|---|---|---|---|---|---|
| dbo.MDT_DS_SAFIR_ProductCategory | dbo.MDT_OUT_ProductCategory | 2 | Code | 1 | |
| dbo.MDT_DS_MFG_ProductCategory | dbo.MDT_OUT_ProductCategory | 1 | NameEN | 0 | |
| dbo.MDT_DS_SAFIR_ProductBrand | dbo.MDT_OUT_ProductBrand | 2 | Code, ID_ProductCategory | 1 | |
| dbo.MDT_DS_MFG_ProductBrand | dbo.MDT_OUT_ProductBrand | 1 | NameEN, ID_ProductCategory | 0 | |
| dbo.MDT_DS_SAFIR_ProductBrandGroup | dbo.MDT_OUT_ProductBrandGroup | 2 | Code, ID_ProductBrand | 1 | |
| dbo.MDT_DS_MFG_ProductBrandGroup | dbo.MDT_OUT_ProductBrandGroup | 1 | NameEN, ID_ProductBrand | 0 | |
| dbo.MDT_DS_SAFIR_ProductFamily | dbo.MDT_OUT_ProductFamily | 2 | Code, ID_ProductBrandGroup | 1 | |
| dbo.MDT_DS_MFG_ProductFamily | dbo.MDT_OUT_ProductFamily | 1 | NameEN, ID_ProductBrandGroup | 0 | |
| dbo.MDT_DS_SAFIR_ProductSubFamily | dbo.MDT_OUT_ProductSubFamily | 2 | Code, ID_ProductFamily | 1 | |
| dbo.MDT_DS_MFG_ProductSubFamily | dbo.MDT_OUT_ProductSubFamily | 1 | NameEN, ID_ProductFamily | 0 | |
| dbo.MDT_DS_SAFIR_DistributionChannels | dbo.MDT_OUT_DistributionChannels | 2 | NameEN | 1 | |
| dbo.MDT_DS_MFG_DistributionChannels | dbo.MDT_OUT_DistributionChannels | 1 | NameEN | 0 | |
| dbo.MDT_DS_SAFIR_CustomerInUnit | dbo.MDT_OUT_CustomerInUnit | 2 | NameEN | 1 | |
| dbo.MDT_DS_MFG_CustomerInUnit | dbo.MDT_OUT_CustomerInUnit | 1 | NameEN | 0 | |
| dbo.MDT_DS_SAFIR_CustomerInRegion | dbo.MDT_OUT_CustomerInRegion | 2 | NameEN, ID_CustomerInUnit | 1 | |
| dbo.MDT_DS_MFG_CustomerInRegion | dbo.MDT_OUT_CustomerInRegion | 1 | NameEN, ID_CustomerInUnit | 0 | |
| dbo.MDT_DS_SAFIR_Company | dbo.MDT_OUT_Company | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_SalesOrganizations | dbo.MDT_OUT_SalesOrganizations | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_Plant | dbo.MDT_OUT_Plant | 2 | Code, Name | 1 | |
| dbo.MDT_DS_MFG_Plant | dbo.MDT_OUT_Plant | 1 | Code | 0 | |
| dbo.MDT_DS_SAFIR_PlantLocation | dbo.MDT_OUT_PlantLocation | 2 | NameEN, ID_Plant | 1 | |
| dbo.MDT_DS_MFG_PlantLocation | dbo.MDT_OUT_PlantLocation | 1 | NameEN, ID_Plant | 0 | |
| dbo.MDT_DS_SAFIR_UnitsOfMeasure | dbo.MDT_OUT_UnitsOfMeasure | 2 | NameEN | 1 | |
| dbo.MDT_DS_SAFIR_ProductStorageConditions | dbo.MDT_OUT_ProductStorageConditions | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_ProductTemperatureConditions | dbo.MDT_OUT_ProductTemperatureConditions | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_ProductStatus | dbo.MDT_OUT_ProductStatus | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_ProductType | dbo.MDT_OUT_ProductType | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_TaxClassification | dbo.MDT_OUT_TaxClassification | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_ProductPromoGroup | dbo.MDT_OUT_ProductPromoGroup | 2 | Code | 0 | |
| dbo.MDT_DS_SAFIR_ProductSKU | dbo.MDT_OUT_ProductSKU | 2 | Code | 0 | |
| dbo.MDT_DS_MFG_ProductSKU | dbo.MDT_OUT_ProductSKU | 1 | Code | 1 | |
| dbo.MDT_DS_SAFIR_SalesDocType | dbo.MDT_OUT_SalesDocType | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_DeliveryType | dbo.MDT_OUT_DeliveryType | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_InvoiceType | dbo.MDT_OUT_InvoiceType | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_Currencies | dbo.MDT_OUT_Currencies | 2 | Code | 1 | |
| dbo.MDT_DS_MFG_Currencies | dbo.MDT_OUT_Currencies | 1 | Code | 0 | |
| dbo.MDT_DS_SAFIR_SalesOrderReasonCategory | dbo.MDT_OUT_SalesOrderReasonCategory | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_SalesOrderReasonClass | dbo.MDT_OUT_SalesOrderReasonClass | 2 | Code, ID_SalesOrderReasonCategory | 1 | |
| dbo.MDT_DS_SAFIR_SalesOrderReason | dbo.MDT_OUT_SalesOrderReason | 2 | Code, ID_SalesOrderReasonClass | 1 | |
| dbo.MDT_DS_SAFIR_Countries | dbo.MDT_OUT_Countries | 2 | Code | 1 | |
| dbo.MDT_DS_MFG_Countries | dbo.MDT_OUT_Countries | 1 | Code | 0 | |
| dbo.MDT_DS_SAFIR_TransportZones | dbo.MDT_OUT_TransportZones | 2 | Code, NameEN | 1 | |
| dbo.MDT_DS_SAFIR_PickingCondition | dbo.MDT_OUT_PickingCondition | 2 | Code | 0 | |
| dbo.MDT_DS_SAFIR_CustomerIn | dbo.MDT_OUT_CustomerIn | 2 | Code | 1 | |
| dbo.MDT_DS_MFG_CustomerIn | dbo.MDT_OUT_CustomerIn | 1 | MFGCustomerCode | 0 | |
| dbo.MDT_DS_SAFIR_RejectionReason | dbo.MDT_OUT_RejectionReason | 2 | Code | 0 | |
| dbo.MDT_DS_MDDB_CalendarKF | dbo.MDT_OUT_CalendarKF | 2 | Date | 0 | |
| dbo.MDT_DS_SAFIR_ProductAssortment | dbo.MDT_OUT_ProductAssortment | 2 | Code | 0 | |
| dbo.MDT_DS_SAFIR_PlantLocationDistinct | dbo.MDT_OUT_PlantLocationDistinct | 2 | Code | 0 | |
| dbo.MDT_DS_OPDB_WarehouseStatus | dbo.MDT_OUT_WarehouseStatus | 2 | Code | 0 | |
| dbo.MDT_DS_OPDB_WarehouseSubStatus | dbo.MDT_OUT_WarehouseSubStatus | 2 | Code | 0 | |
| dbo.MDT_DS_SAFIR_PurchaseOrderType | dbo.MDT_OUT_PurchaseOrderType | 2 | Code | 0 | |
| dbo.MDT_DS_STAR_POSMBudget | dbo.MDT_OUT_POSMBudget | 2 | NameRU | 0 | |
| dbo.MDT_DS_SAFIR_EAN | dbo.MDT_OUT_EAN | 2 | Code | 0 | |
| dbo.MDT_DS_SAFIR_SellInCondition | dbo.MDT_OUT_SellInCondition | 2 | Code | 0 | |
| dbo.MDT_DS_SOPTool_CustomerInType | dbo.MDT_OUT_CustomerInType | 2 | NameEN | 1 | |
| dbo.MDT_DS_SAFIR_CalendarKF | dbo.MDT_OUT_CalendarKF | 2 | Date | 0 | |
| dbo.MDT_DS_BCP_WarehouseOperationType | dbo.MDT_OUT_WarehouseOperationType | 2 | Code | 0 | |
| dbo.MDT_DS_DWH_ClosingStockFreeze | dbo.MDT_OUT_ClosingStockFreeze | 2 | ID_YearMonthWeek | 0 | |
| dbo.MDT_DS_SOPTool_TDP_Scenario | dbo.MDT_OUT_TDP_Scenario | 2 | Code | 0 | |
| dbo.MDT_DS_CHIPITA_ProductCategory | dbo.MDT_OUT_ProductCategory | 2 | Code | 0 | |
| dbo.MDT_DS_CHIPITA_ProductBrand | dbo.MDT_OUT_ProductBrand | 2 | Code | 0 | |
| dbo.MDT_DS_CHIPITA_ProductBrandGroup | dbo.MDT_OUT_ProductBrandGroup | 2 | Code | 0 | |
| dbo.MDT_DS_CHIPITA_ProductFamily | dbo.MDT_OUT_ProductFamily | 2 | Code | 0 | |
| dbo.MDT_DS_CHIPITA_ProductSubFamily | dbo.MDT_OUT_ProductSubFamily | 2 | Code | 0 | |
| dbo.MDT_DS_CHIPITA_ProductSKU | dbo.MDT_OUT_ProductSKU | 2 | Code | 0 | |
| dbo.MDT_DS_CHIPITA_CustomerIn | dbo.MDT_OUT_CustomerIn | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_CustomerInSystem | dbo.MDT_OUT_CustomerInSystem | 2 | Code | 1 | |
| dbo.MDT_DS_CHIPITA_CustomerInSystem | dbo.MDT_OUT_CustomerInSystem | 2 | Code | 1 | |
| dbo.MDT_DS_SAFIR_RegionRF | dbo.MDT_OUT_RegionRF | 2 | Code | 1 | |
| dbo.MDT_DS_SOP_RegionRF | dbo.MDT_OUT_RegionRF | 2 | Code | 1 | |
| dbo.MDT_DS_CHGO_RegionRF | dbo.MDT_OUT_RegionRF | 1 | NameRU | 1 |
2. Auto Updated¶
- Тип: Sequence Container
- Описание: Автоматическое обновление данных в OUT таблицах
- Цикличность: Foreach Loop Container (List DS tables)
2.1 Execute usp_MDT_OUT_Updated¶
- Тип: Execute SQL Task
- Описание: Обновление существующих записей в OUT таблицах
- Процедура: etl.usp_MDT_OUT_Updated
- Параметры мэппинга данных:
- @Batch → User::Batch
- @MDT_Link_Name → User::MDT_Link_Name
- @MDT_DB_Name → User::MDT_DB_Name
- @TableName_Source → User::TableName_Source
- @TableName_Destination → User::TableName_Destination
- @TableMapping → User::TableMapping
- @TableColumnsExcluded → User::TableColumnsExcluded
- @TableColumnsIncluded → User::TableColumnsIncluded
- @TableAggregationType → User::TableAggregationType
- @TableColumnsNewMarked → User::TableColumnsNewMarked
- @TableAllRecords → User::TableAllRecords
Используемые объекты:
| TableName_Source | TableName_Destination | TableColumnsIncluded | TableColumnsExcluded | TableAggregationType | TableColumnsNewMarked | TableAllRecords |
|---|---|---|---|---|---|---|
| dbo.MDT_DS_SAFIR_ProductCategory | dbo.MDT_OUT_ProductCategory | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductBrand | dbo.MDT_OUT_ProductBrand | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductBrandGroup | dbo.MDT_OUT_ProductBrandGroup | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductFamily | dbo.MDT_OUT_ProductFamily | DISTINCT | 0 | 0 | ||
| dbo.MDT_DS_SAFIR_ProductSubFamily | dbo.MDT_OUT_ProductSubFamily | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_DistributionChannels | dbo.MDT_OUT_DistributionChannels | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_CustomerInUnit | dbo.MDT_OUT_CustomerInUnit | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_CustomerInRegion | dbo.MDT_OUT_CustomerInRegion | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_Company | dbo.MDT_OUT_Company | NameEN, NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_SalesOrganizations | dbo.MDT_OUT_SalesOrganizations | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_Plant | dbo.MDT_OUT_Plant | DISTINCT | 0 | 1 | ||
| dbo.MDT_DS_SAFIR_PlantLocation | dbo.MDT_OUT_PlantLocation | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_UnitsOfMeasure | dbo.MDT_OUT_UnitsOfMeasure | NameEN, NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductStorageConditions | dbo.MDT_OUT_ProductStorageConditions | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductTemperatureConditions | dbo.MDT_OUT_ProductTemperatureConditions | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductStatus | dbo.MDT_OUT_ProductStatus | NameEN, NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductType | dbo.MDT_OUT_ProductType | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductPromoGroup | dbo.MDT_OUT_ProductPromoGroup | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductSKU | dbo.MDT_OUT_ProductSKU | ProductSeasonality | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_SalesDocType | dbo.MDT_OUT_SalesDocType | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_DeliveryType | dbo.MDT_OUT_DeliveryType | NameEN, NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_InvoiceType | dbo.MDT_OUT_InvoiceType | NameEN, NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_Currencies | dbo.MDT_OUT_Currencies | NameEN, NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_SalesOrderReasonCategory | dbo.MDT_OUT_SalesOrderReasonCategory | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_SalesOrderReasonClass | dbo.MDT_OUT_SalesOrderReasonClass | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_SalesOrderReason | dbo.MDT_OUT_SalesOrderReason | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_Countries | dbo.MDT_OUT_Countries | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_TransportZones | dbo.MDT_OUT_TransportZones | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_PickingCondition | dbo.MDT_OUT_PickingCondition | DISTINCT | 0 | 0 | ||
| dbo.MDT_DS_SAFIR_CustomerIn | dbo.MDT_OUT_CustomerIn | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_MFG_CustomerIn | dbo.MDT_OUT_CustomerIn | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_MDDB_CalendarKF | dbo.MDT_OUT_CalendarKF | Working | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_STAR_POSMBudget | dbo.MDT_OUT_POSMBudget | NameRU | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_DWH_Constants | dbo.MDT_OUT_Constants | DISTINCT | 0 | 0 | ||
| dbo.MDT_DS_SOPTool_CustomerInType | dbo.MDT_OUT_CustomerInType | DISTINCT | 0 | 0 | ||
| dbo.MDT_DS_SAFIR_CalendarKF | dbo.MDT_OUT_CalendarKF | Working | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_BCP_WarehouseOperationType | dbo.MDT_OUT_WarehouseOperationType | Code, NameEN | NameRU | DISTINCT | 0 | 0 |
| dbo.MDT_DS_DWH_ClosingStockFreeze | dbo.MDT_OUT_ClosingStockFreeze | ID_DateClosingStockFreeze | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SOPTool_TDP_Scenario | dbo.MDT_OUT_TDP_Scenario | FlagActive | DISTINCT | 0 | 1 | |
| dbo.MDT_DS_CHIPITA_ProductSKU | dbo.MDT_OUT_ProductSKU | ID_ProductSubFamily, TaxClassification | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_ProductSKU | dbo.MDT_OUT_ProductSKU | ID_ProductSubFamily | DISTINCT | 0 | 0 | |
| dbo.MDT_DS_SAFIR_CustomerInSystem | dbo.MDT_OUT_CustomerInSystem | DISTINCT | 0 | 0 |
3. Other Tables DS MDT¶
- Тип: Sequence Container
- Описание: Обработка прочих DS таблиц MDT
3.1 Clear DS tables¶
- Тип: Foreach Loop Container
- Описание: Очистка DS таблиц
- Цикличность: Foreach Loop Container
Подшаг: Delete DS tables rows - Тип: Execute SQL Task - Описание: Удаление строк из DS таблиц - Процедура: etl.usp_MDT_DS_Load - Параметры мэппинга данных: - @Batch → User::Batch - @MDT_Link_Name → User::MDT_Link_Name - @MDT_DB_Name → User::MDT_DB_Name - @DS_TableName_Source → User::DS_TableName_Source - @DS_TableName_Destination → User::DS_TableName_Destination - @DS_TableColumnsExcluded → User::DS_TableColumnsExcluded - @pnMode = 1
3.2 Filling DS tables¶
- Тип: Foreach Loop Container
- Описание: Заполнение DS таблиц
- Цикличность: Foreach Loop Container
Подшаг: Insert and Update DS tables rows - Тип: Execute SQL Task - Описание: Вставка и обновление строк в DS таблицах - Процедура: etl.usp_MDT_DS_Load - Параметры мэппинга данных: - @Batch → User::Batch - @MDT_Link_Name → User::MDT_Link_Name - @MDT_DB_Name → User::MDT_DB_Name - @DS_TableName_Source → User::DS_TableName_Source - @DS_TableName_Destination → User::DS_TableName_Destination - @DS_TableColumnsExcluded → User::DS_TableColumnsExcluded - @pnMode = 0
Используемые объекты:
| DS_TableName_Source | DS_TableName_Destination | DS_TableColumnsExcluded |
|---|---|---|
| dbo.SA_SOPTool_CustomerInType | dbo.MDT_DS_SOPTool_CustomerInType | |
| dbo.SA_BCP_WarehouseOperationType | dbo.MDT_DS_BCP_WarehouseOperationType | |
| dbo.SA_DWH_ClosingStockFreeze | dbo.MDT_DS_DWH_ClosingStockFreeze | |
| dbo.SA_SOPTool_TDP_Scenario | dbo.MDT_DS_SOPTool_TDP_Scenario | |
| dbo.SA_CHIPITA_ProductCategory | dbo.MDT_DS_CHIPITA_ProductCategory | |
| dbo.SA_CHIPITA_ProductBrand | dbo.MDT_DS_CHIPITA_ProductBrand | |
| dbo.SA_CHIPITA_ProductBrandGroup | dbo.MDT_DS_CHIPITA_ProductBrandGroup | |
| dbo.SA_CHIPITA_ProductFamily | dbo.MDT_DS_CHIPITA_ProductFamily | |
| dbo.SA_CHIPITA_ProductSubFamily | dbo.MDT_DS_CHIPITA_ProductSubFamily | |
| dbo.SA_CHIPITA_ProductSKU | dbo.MDT_DS_CHIPITA_ProductSKU | |
| dbo.SA_CHIPITA_CustomerIn | dbo.MDT_DS_CHIPITA_CustomerIn | |
| dbo.SA_CHIPITA_CustomerInSystem | dbo.MDT_DS_CHIPITA_CustomerInSystem | |
| dbo.SA_SOP_RegionRF | dbo.MDT_DS_SOP_RegionRF | |
| dbo.SA_CHGO_RegionRF | dbo.MDT_DS_CHGO_RegionRF |
4. Stage Area filling¶
- Тип: Sequence Container
- Описание: Заполнение Stage Area таблицами из MDT
4.1 Filling SA Other tables¶
- Тип: Foreach Loop Container
- Описание: Заполнение прочих SA таблиц
- Цикличность: Foreach Loop Container
Подшаг: Execute usp_MDT_ExportDataToMDT
- Тип: Execute SQL Task
- Процедура: etl.usp_MDT_ExportDataToMDT
- Параметры мэппинга данных:
- @Batch → User::Batch
- @DWH_Link_Name → User::DWH_Link_Name
- @DWH_DB_Name → User::DWH_DB_Name
- @MDT_Link_Name → User::MDT_Link_Name
- @MDT_DB_Name → User::MDT_DB_Name
- @SA_TableName_Source → User::SA_TableName_Source
- @SA_TableName_Destination → User::SA_TableName_Destination
Используемые объекты:
| SA_TableName_Source | SA_TableName_Destination |
|---|---|
| dbo.VIEW_SA_CONTR_TransportTemperatureMode | dbo.SA_CONTR_TransportTemperatureMode |
| dbo.VIEW_SA_CONTR_TransportType | dbo.SA_CONTR_TransportType |
| dbo.VIEW_SA_MDDB_CalendarKF | dbo.SA_MDDB_CalendarKF |
| dbo.VIEW_SA_OPDB_WarehouseStatus | dbo.SA_OPDB_WarehouseStatus |
| dbo.VIEW_SA_OPDB_WarehouseSubStatus | dbo.SA_OPDB_WarehouseSubStatus |
| dbo.VIEW_SA_STAR_POSMBudget | dbo.SA_STAR_POSMBudget |
| dbo.VIEW_SA_DWH_Constants | dbo.SA_DWH_Constants |
| dbo.VIEW_SA_SOPTool_CustomerInType | dbo.SA_SOPTool_CustomerInType |
| dbo.VIEW_SA_BCP_WarehouseOperationType | dbo.SA_BCP_WarehouseOperationType |
| dbo.VIEW_SA_DWH_ClosingStockFreeze | dbo.SA_DWH_ClosingStockFreeze |
| dbo.VIEW_SA_SOPTool_TDP_Scenario | dbo.SA_SOPTool_TDP_Scenario |
| dbo.VIEW_SA_CHIPITA_ProductCategory | dbo.SA_CHIPITA_ProductCategory |
| dbo.VIEW_SA_CHIPITA_ProductBrand | dbo.SA_CHIPITA_ProductBrand |
| dbo.VIEW_SA_CHIPITA_ProductBrandGroup | dbo.SA_CHIPITA_ProductBrandGroup |
| dbo.VIEW_SA_CHIPITA_ProductFamily | dbo.SA_CHIPITA_ProductFamily |
| dbo.VIEW_SA_CHIPITA_ProductSubFamily | dbo.SA_CHIPITA_ProductSubFamily |
| dbo.VIEW_SA_CHIPITA_ProductSKU | dbo.SA_CHIPITA_ProductSKU |
| dbo.VIEW_SA_CHIPITA_CustomerIn | dbo.SA_CHIPITA_CustomerIn |
| dbo.VIEW_SA_CHIPITA_CustomerInSystem | dbo.SA_CHIPITA_CustomerInSystem |
| dbo.VIEW_SA_SOP_RegionRF | dbo.SA_SOP_RegionRF |
| dbo.VIEW_SA_CHGO_RegionRF | dbo.SA_CHGO_RegionRF |
4.2 Filling SA SAFIR tables¶
- Тип: Foreach Loop Container
- Описание: Заполнение SA таблиц SAFIR
- Цикличность: Foreach Loop Container
Подшаг: Execute usp_MDT_ExportDataToMDT
- Тип: Execute SQL Task
- Процедура: etl.usp_MDT_ExportDataToMDT
- Параметры мэппинга данных: (аналогично 4.1)
Используемые объекты:
| SA_TableName_Source | SA_TableName_Destination |
|---|---|
| dbo.VIEW_SA_SAFIR_ProductCategory | dbo.SA_SAFIR_ProductCategory |
| dbo.VIEW_SA_SAFIR_ProductBrand | dbo.SA_SAFIR_ProductBrand |
| dbo.VIEW_SA_SAFIR_ProductBrandGroup | dbo.SA_SAFIR_ProductBrandGroup |
| dbo.VIEW_SA_SAFIR_ProductFamily | dbo.SA_SAFIR_ProductFamily |
| dbo.VIEW_SA_SAFIR_ProductSubFamily | dbo.SA_SAFIR_ProductSubFamily |
| dbo.VIEW_SA_SAFIR_DistributionChannels | dbo.SA_SAFIR_DistributionChannels |
| dbo.VIEW_SA_SAFIR_CustomerInUnit | dbo.SA_SAFIR_CustomerInUnit |
| dbo.VIEW_SA_SAFIR_CustomerInRegion | dbo.SA_SAFIR_CustomerInRegion |
| dbo.VIEW_SA_SAFIR_Company | dbo.SA_SAFIR_Company |
| dbo.VIEW_SA_SAFIR_SalesOrganizations | dbo.SA_SAFIR_SalesOrganizations |
| dbo.VIEW_SA_SAFIR_Plant | dbo.SA_SAFIR_Plant |
| dbo.VIEW_SA_SAFIR_PlantLocation | dbo.SA_SAFIR_PlantLocation |
| dbo.VIEW_SA_SAFIR_UnitsOfMeasure | dbo.SA_SAFIR_UnitsOfMeasure |
| dbo.VIEW_SA_SAFIR_ProductStorageConditions | dbo.SA_SAFIR_ProductStorageConditions |
| dbo.VIEW_SA_SAFIR_ProductTemperatureConditions | dbo.SA_SAFIR_ProductTemperatureConditions |
| dbo.VIEW_SA_SAFIR_ProductStatus | dbo.SA_SAFIR_ProductStatus |
| dbo.VIEW_SA_SAFIR_ProductType | dbo.SA_SAFIR_ProductType |
| dbo.VIEW_SA_SAFIR_ProductSKU | dbo.SA_SAFIR_ProductSKU |
| dbo.VIEW_SA_SAFIR_SalesDocType | dbo.SA_SAFIR_SalesDocType |
| dbo.VIEW_SA_SAFIR_DeliveryType | dbo.SA_SAFIR_DeliveryType |
| dbo.VIEW_SA_SAFIR_InvoiceType | dbo.SA_SAFIR_InvoiceType |
| dbo.VIEW_SA_SAFIR_Currencies | dbo.SA_SAFIR_Currencies |
| dbo.VIEW_SA_SAFIR_SalesOrderReasonCategory | dbo.SA_SAFIR_SalesOrderReasonCategory |
| dbo.VIEW_SA_SAFIR_SalesOrderReasonClass | dbo.SA_SAFIR_SalesOrderReasonClass |
| dbo.VIEW_SA_SAFIR_SalesOrderReason | dbo.SA_SAFIR_SalesOrderReason |
| dbo.VIEW_SA_SAFIR_Countries | dbo.SA_SAFIR_Countries |
| dbo.VIEW_SA_SAFIR_TransportZones | dbo.SA_SAFIR_TransportZones |
| dbo.VIEW_SA_SAFIR_PickingCondition | dbo.SA_SAFIR_PickingCondition |
| dbo.VIEW_SA_SAFIR_CustomerIn | dbo.SA_SAFIR_CustomerIn |
| dbo.VIEW_SA_SAFIR_RejectionReason | dbo.SA_SAFIR_RejectionReason |
| dbo.VIEW_SA_SAFIR_ProductAssortment | dbo.SA_SAFIR_ProductAssortment |
| dbo.VIEW_SA_SAFIR_PlantLocationDistinct | dbo.SA_SAFIR_PlantLocationDistinct |
| dbo.VIEW_SA_SAFIR_BusinessUnit | dbo.SA_SAFIR_BusinessUnit |
| dbo.VIEW_SA_SAFIR_ProductSKUBusinessUnit | dbo.SA_SAFIR_ProductSKUBusinessUnit |
| dbo.VIEW_SA_SAFIR_PurchaseOrderType | dbo.SA_SAFIR_PurchaseOrderType |
| dbo.VIEW_SA_SAFIR_EAN | dbo.SA_SAFIR_EAN |
| dbo.VIEW_SA_SAFIR_SellInCondition | dbo.SA_SAFIR_SellInCondition |
| dbo.VIEW_SA_SAFIR_TaxClassification | dbo.SA_SAFIR_TaxClassification |
| dbo.VIEW_SA_SAFIR_CalendarKF | dbo.SA_SAFIR_CalendarKF |
| dbo.VIEW_SA_SAFIR_ProductPromoGroup | dbo.SA_SAFIR_ProductPromoGroup |
| dbo.VIEW_SA_SAFIR_CustomerInSystem | dbo.SA_SAFIR_CustomerInSystem |
| dbo.VIEW_SA_SAFIR_RegionRF | dbo.SA_SAFIR_RegionRF |
5. Table view¶
- Тип: Sequence Container
- Описание: Генерация представлений для связей источников
5.1 GenerateSourceRelationship¶
- Тип: Execute SQL Task
- Описание: Генерация связей между источниками данных
- Процедура: etl.usp_MDT_GenerateSourceRelationship
6. Tables Dimension to DWH¶
- Тип: Sequence Container
- Описание: Загрузка измерений из MDT в DWH
- Цикличность: Foreach Loop Container (Filling DIM tables)
6.1 Execute usp_MDT_Load_DIM¶
- Тип: Execute SQL Task
- Описание: Загрузка данных измерений в DWH
- Процедура: etl.usp_MDT_Load_DIM
- Параметры мэппинга данных:
- @Batch → User::Batch
- @DWH_Link_Name → User::DWH_Link_Name
- @DWH_DB_Name → User::DWH_DB_Name
- @MDT_Link_Name → User::MDT_Link_Name
- @MDT_DB_Name → User::MDT_DB_Name
- @TableName_Source → User::TableName_Source
- @TableName_Destination → User::TableName_Destination
- @TableMapping → User::TableMapping
- @TableColumnsExcluded → User::TableColumnsExcluded
- @TableColumnsIncluded → User::TableColumnsIncluded
Используемые объекты:
| TableName_Source | TableName_Destination | TableColumnsExcluded |
|---|---|---|
| mdt.MDT_OUT_ProductCategory | dbo.D_ProductCategory | |
| mdt.MDT_OUT_ProductBrand | dbo.D_ProductBrand | |
| mdt.MDT_OUT_ProductBrandGroup | dbo.D_ProductBrandGroup | |
| mdt.MDT_OUT_ProductFamily | dbo.D_ProductFamily | |
| mdt.MDT_OUT_ProductSubFamily | dbo.D_ProductSubFamily | |
| mdt.MDT_OUT_DistributionChannels | dbo.D_DistributionChannels | |
| mdt.MDT_OUT_CustomerInUnit | dbo.D_CustomerInUnit | |
| mdt.MDT_OUT_CustomerInRegion | dbo.D_CustomerInRegion | |
| mdt.MDT_OUT_Company | dbo.D_Company | |
| mdt.MDT_OUT_SalesOrganizations | dbo.D_SalesOrganizations | |
| mdt.MDT_OUT_PlantType | dbo.D_PlantType | |
| mdt.MDT_OUT_Plant | dbo.D_Plant | |
| mdt.MDT_OUT_PlantLocation | dbo.D_PlantLocation | |
| mdt.MDT_OUT_UnitsOfMeasure | dbo.D_UnitsOfMeasure | |
| mdt.MDT_OUT_ProductStorageConditions | dbo.D_ProductStorageConditions | |
| mdt.MDT_OUT_ProductTemperatureConditions | dbo.D_ProductTemperatureConditions | |
| mdt.MDT_OUT_ProductStatus | dbo.D_ProductStatus | |
| mdt.MDT_OUT_ProductType | dbo.D_ProductType | |
| mdt.MDT_OUT_Countries | dbo.D_Countries | |
| mdt.MDT_OUT_TaxClassification | dbo.D_TaxClassification | |
| mdt.MDT_OUT_ProductPromoGroup | dbo.D_ProductPromoGroup | |
| mdt.MDT_OUT_ProductSKU | dbo.D_ProductSKU | |
| mdt.MDT_OUT_SalesDocTypeCategory | dbo.D_SalesDocTypeCategory | |
| mdt.MDT_OUT_SalesDocType | dbo.D_SalesDocType | |
| mdt.MDT_OUT_DeliveryType | dbo.D_DeliveryType | |
| mdt.MDT_OUT_InvoiceType | dbo.D_InvoiceType | |
| mdt.MDT_OUT_Currencies | dbo.D_Currencies | |
| mdt.MDT_OUT_SalesOrderReasonCategory | dbo.D_SalesOrderReasonCategory | |
| mdt.MDT_OUT_SalesOrderReasonClass | dbo.D_SalesOrderReasonClass | |
| mdt.MDT_OUT_SalesOrderReason | dbo.D_SalesOrderReason | |
| mdt.MDT_OUT_TransportZones | dbo.D_TransportZones | |
| mdt.MDT_OUT_CustomerInGroup | dbo.D_CustomerInGroup | |
| mdt.MDT_OUT_CustomerInChain | dbo.D_CustomerInChain | |
| mdt.MDT_OUT_CustomerInFormat | dbo.D_CustomerInFormat | |
| mdt.MDT_OUT_CustomerInMacroRegion | dbo.D_CustomerInMacroRegion | |
| mdt.MDT_OUT_PickingCondition | dbo.D_PickingCondition | |
| mdt.MDT_OUT_CustomerIn | dbo.D_CustomerIn | |
| mdt.MDT_OUT_KPI_CFR | dbo.D_KPI_CFR | |
| mdt.MDT_OUT_KPI_OSC | dbo.D_KPI_OSC | |
| mdt.MDT_OUT_OrderStatus | dbo.D_OrderStatus | |
| mdt.MDT_OUT_TransportTemperatureMode | dbo.D_TransportTemperatureMode | |
| mdt.MDT_OUT_TransportTypeGroup | dbo.D_TransportTypeGroup | |
| mdt.MDT_OUT_TransportType | dbo.D_TransportType | |
| mdt.MDT_OUT_RejectionReason | dbo.D_RejectionReason | |
| mdt.MDT_OUT_CalendarKF | dbo.D_CalendarKF | |
| mdt.MDT_OUT_ProductAssortment | dbo.D_ProductAssortment | |
| mdt.MDT_OUT_PlantLocationDistinct | dbo.D_PlantLocationDistinct | |
| mdt.MDT_OUT_BusinessUnit | dbo.D_BusinessUnit | |
| mdt.MDT_OUT_StockType | dbo.D_StockType | |
| mdt.MDT_OUT_WarehouseStatus | dbo.D_WarehouseStatus | |
| mdt.MDT_OUT_WarehouseSubStatus | dbo.D_WarehouseSubStatus | |
| mdt.MDT_OUT_StockCalculationRules | dbo.D_StockCalculationRules | |
| mdt.MDT_OUT_ProductSKUBusinessUnit | dbo.D_ProductSKUBusinessUnit | |
| mdt.MDT_OUT_PlantSalesOrganization | dbo.D_PlantSalesOrganization | |
| mdt.MDT_OUT_PurchaseOrderType | dbo.D_PurchaseOrderType | |
| mdt.MDT_OUT_POSMBudgetType | dbo.D_POSMBudgetType | |
| mdt.MDT_OUT_POSMBudget | dbo.D_POSMBudget | |
| mdt.MDT_OUT_POSMCategory | dbo.D_POSMCategory | |
| mdt.MDT_OUT_POSM | dbo.D_POSM | |
| mdt.MDT_OUT_EAN | dbo.D_EAN | |
| mdt.MDT_OUT_CustomerIn_SCD | dbo.D_CustomerIn_SCD | |
| mdt.MDT_OUT_SellInConditionGroup | dbo.D_SellInConditionGroup | |
| mdt.MDT_OUT_SellInCondition | dbo.D_SellInCondition | |
| mdt.MDT_OUT_TaxClassification_History | dbo.D_TaxClassification_History | |
| mdt.MDT_OUT_CustomerInPriceList | dbo.D_CustomerInPriceList | |
| mdt.MDT_OUT_CustomerInType | dbo.D_CustomerInType | |
| mdt.MDT_OUT_Constants | dbo.D_Constants | |
| mdt.MDT_OUT_EmployeeTitle | dbo.D_EmployeeTitle | |
| mdt.MDT_OUT_WarehouseOperationType | dbo.D_WarehouseOperationType | |
| mdt.MDT_OUT_WarehouseContractOperation | dbo.D_WarehouseContractOperation | |
| mdt.MDT_OUT_WarehouseContractTerms | dbo.D_WarehouseContractTerms | ID_DateBegin, ID_DateEnd |
| mdt.MDT_OUT_FCUReasonCategory | dbo.D_FCUReasonCategory | |
| mdt.MDT_OUT_FCUReason | dbo.D_FCUReason | |
| mdt.MDT_OUT_ClosingStockFreeze | dbo.D_ClosingStockFreeze | |
| mdt.MDT_OUT_TDP_Scenario | dbo.D_TDP_Scenario | |
| mdt.MDT_OUT_ClaimStatus | dbo.D_ClaimStatus | |
| mdt.MDT_OUT_LicType | dbo.D_LicType | |
| mdt.MDT_OUT_TransportationEquipment | dbo.D_TransportationEquipment | |
| mdt.MDT_OUT_POSChain_ExceptWOS | dbo.D_POSChain_ExceptWOS | |
| mdt.MDT_OUT_CustomerInSystem_Remapped | dbo.D_CustomerInSystem_Remapped | ID_CustomerInHierarchy |
| mdt.MDT_OUT_RegionRF | dbo.D_RegionRF | |
| mdt.MDT_OUT_CustomerInSystem | dbo.D_CustomerInSystem | ID_CustomerInHierarchy |
| mdt.MDT_OUT_CustomerIn_Remapped | dbo.D_CustomerIn_Remapped | ID_CustomerInHierarchy |
| mdt.MDT_OUT_OrderPickingType | dbo.D_OrderPickingType | |
| mdt.MDT_OUT_OrderPickingType_CustomerInRegion | dbo.D_OrderPickingType_CustomerInRegion |
7. Tables DS MDT MFG¶
- Тип: Sequence Container
- Описание: Обработка DS таблиц для MFG (Manufacturing)
7.1 Clear DS tables¶
- Тип: Foreach Loop Container
- Описание: Очистка DS таблиц MFG
- Цикличность: Foreach Loop Container
Подшаг: Delete DS tables rows - Тип: Execute SQL Task - Описание: Удаление строк из DS таблиц - Процедура: etl.usp_MDT_DS_Load - Параметры мэппинга данных: - @Batch → User::Batch - @MDT_Link_Name → User::MDT_Link_Name - @MDT_DB_Name → User::MDT_DB_Name - @DS_TableName_Source → User::DS_TableName_Source - @DS_TableName_Destination → User::DS_TableName_Destination - @DS_TableColumnsExcluded → User::DS_TableColumnsExcluded - @pnMode = 1
7.2 Filling DS tables¶
- Тип: Foreach Loop Container
- Описание: Заполнение DS таблиц MFG
- Цикличность: Foreach Loop Container
Подшаг: Insert and Update DS tables rows - Тип: Execute SQL Task - Описание: Вставка и обновление строк в DS таблицах - Процедура: etl.usp_MDT_DS_Load - Параметры мэппинга данных: - @Batch → User::Batch - @MDT_Link_Name → User::MDT_Link_Name - @MDT_DB_Name → User::MDT_DB_Name - @DS_TableName_Source → User::DS_TableName_Source - @DS_TableName_Destination → User::DS_TableName_Destination - @DS_TableColumnsExcluded → User::DS_TableColumnsExcluded - @pnMode = 0
Используемые объекты:
| DS_TableName_Source | DS_TableName_Destination |
|---|---|
| dbo.SA_MFG_ProductSKU | dbo.MDT_DS_MFG_ProductSKU |
| dbo.SA_MFG_ProductSubFamily | dbo.MDT_DS_MFG_ProductSubFamily |
| dbo.SA_MFG_ProductFamily | dbo.MDT_DS_MFG_ProductFamily |
| dbo.SA_MFG_ProductBrandGroup | dbo.MDT_DS_MFG_ProductBrandGroup |
| dbo.SA_MFG_ProductBrand | dbo.MDT_DS_MFG_ProductBrand |
| dbo.SA_MFG_ProductCategory | dbo.MDT_DS_MFG_ProductCategory |
| dbo.SA_MFG_CustomerIn | dbo.MDT_DS_MFG_CustomerIn |
| dbo.SA_MFG_DistributionChannels | dbo.MDT_DS_MFG_DistributionChannels |
| dbo.SA_MFG_CustomerInRegion | dbo.MDT_DS_MFG_CustomerInRegion |
| dbo.SA_MFG_CustomerInUnit | dbo.MDT_DS_MFG_CustomerInUnit |
| dbo.SA_MFG_PlantLocation | dbo.MDT_DS_MFG_PlantLocation |
| dbo.SA_MFG_Plant | dbo.MDT_DS_MFG_Plant |
| dbo.SA_MFG_UnitsOfMeasure | dbo.MDT_DS_MFG_UnitsOfMeasure |
| dbo.SA_MFG_ProductTemperatureConditions | dbo.MDT_DS_MFG_ProductTemperatureConditions |
| dbo.SA_MFG_ProductStatus | dbo.MDT_DS_MFG_ProductStatus |
| dbo.SA_MFG_ProductType | dbo.MDT_DS_MFG_ProductType |
| dbo.SA_MFG_SalesDocType | dbo.MDT_DS_MFG_SalesDocType |
| dbo.SA_MFG_Currencies | dbo.MDT_DS_MFG_Currencies |
| dbo.SA_MFG_SalesOrderReason | dbo.MDT_DS_MFG_SalesOrderReason |
| dbo.SA_MFG_SalesOrderReasonClass | dbo.MDT_DS_MFG_SalesOrderReasonClass |
| dbo.SA_MFG_SalesOrderReasonCategory | dbo.MDT_DS_MFG_SalesOrderReasonCategory |
| dbo.SA_MFG_Countries | dbo.MDT_DS_MFG_Countries |
| dbo.SA_MFG_TransportZones | dbo.MDT_DS_MFG_TransportZones |
| dbo.SA_CONTR_TransportTemperatureMode | dbo.MDT_DS_CONTR_TransportTemperatureMode |
| dbo.SA_CONTR_TransportType | dbo.MDT_DS_CONTR_TransportType |
| dbo.SA_MDDB_CalendarKF | dbo.MDT_DS_MDDB_CalendarKF |
| dbo.SA_OPDB_WarehouseSubStatus | dbo.MDT_DS_OPDB_WarehouseSubStatus |
| dbo.SA_OPDB_WarehouseStatus | dbo.MDT_DS_OPDB_WarehouseStatus |
| dbo.SA_STAR_POSMBudget | dbo.MDT_DS_STAR_POSMBudget |
| dbo.SA_DWH_Constants | dbo.MDT_DS_DWH_Constants |
8. Tables DS MDT Safir¶
- Тип: Sequence Container
- Описание: Обработка DS таблиц для Safir
8.1 Clear DS tables¶
- Тип: Foreach Loop Container
- Описание: Очистка DS таблиц Safir
- Цикличность: Foreach Loop Container
Подшаг: Delete DS tables rows
- Тип: Execute SQL Task
- Описание: Удаление строк из DS таблиц
- Процедура: etl.usp_MDT_DS_Load
- Параметры мэппинга данных: (аналогично 7.1)
8.2 Filling DS tables¶
- Тип: Foreach Loop Container
- Описание: Заполнение DS таблиц Safir
- Цикличность: Foreach Loop Container
Подшаг: Insert and Update DS tables rows
- Тип: Execute SQL Task
- Описание: Вставка и обновление строк в DS таблицах
- Процедура: etl.usp_MDT_DS_Load
- Параметры мэппинга данных: (аналогично 7.2)
Используемые объекты:
| DS_TableName_Source | DS_TableName_Destination |
|---|---|
| dbo.SA_SAFIR_ProductSKU | dbo.MDT_DS_SAFIR_ProductSKU |
| dbo.SA_SAFIR_ProductSubFamily | dbo.MDT_DS_SAFIR_ProductSubFamily |
| dbo.SA_SAFIR_ProductFamily | dbo.MDT_DS_SAFIR_ProductFamily |
| dbo.SA_SAFIR_ProductBrandGroup | dbo.MDT_DS_SAFIR_ProductBrandGroup |
| dbo.SA_SAFIR_ProductBrand | dbo.MDT_DS_SAFIR_ProductBrand |
| dbo.SA_SAFIR_ProductCategory | dbo.MDT_DS_SAFIR_ProductCategory |
| dbo.SA_SAFIR_PickingCondition | dbo.MDT_DS_SAFIR_PickingCondition |
| dbo.SA_SAFIR_CustomerIn | dbo.MDT_DS_SAFIR_CustomerIn |
| dbo.SA_SAFIR_DistributionChannels | dbo.MDT_DS_SAFIR_DistributionChannels |
| dbo.SA_SAFIR_CustomerInRegion | dbo.MDT_DS_SAFIR_CustomerInRegion |
| dbo.SA_SAFIR_CustomerInUnit | dbo.MDT_DS_SAFIR_CustomerInUnit |
| dbo.SA_SAFIR_SalesOrganizations | dbo.MDT_DS_SAFIR_SalesOrganizations |
| dbo.SA_SAFIR_Company | dbo.MDT_DS_SAFIR_Company |
| dbo.SA_SAFIR_PlantLocation | dbo.MDT_DS_SAFIR_PlantLocation |
| dbo.SA_SAFIR_Plant | dbo.MDT_DS_SAFIR_Plant |
| dbo.SA_SAFIR_UnitsOfMeasure | dbo.MDT_DS_SAFIR_UnitsOfMeasure |
| dbo.SA_SAFIR_ProductStorageConditions | dbo.MDT_DS_SAFIR_ProductStorageConditions |
| dbo.SA_SAFIR_ProductTemperatureConditions | dbo.MDT_DS_SAFIR_ProductTemperatureConditions |
| dbo.SA_SAFIR_ProductStatus | dbo.MDT_DS_SAFIR_ProductStatus |
| dbo.SA_SAFIR_ProductType | dbo.MDT_DS_SAFIR_ProductType |
| dbo.SA_SAFIR_SalesDocType | dbo.MDT_DS_SAFIR_SalesDocType |
| dbo.SA_SAFIR_DeliveryType | dbo.MDT_DS_SAFIR_DeliveryType |
| dbo.SA_SAFIR_InvoiceType | dbo.MDT_DS_SAFIR_InvoiceType |
| dbo.SA_SAFIR_Currencies | dbo.MDT_DS_SAFIR_Currencies |
| dbo.SA_SAFIR_SalesOrderReason | dbo.MDT_DS_SAFIR_SalesOrderReason |
| dbo.SA_SAFIR_SalesOrderReasonClass | dbo.MDT_DS_SAFIR_SalesOrderReasonClass |
| dbo.SA_SAFIR_SalesOrderReasonCategory | dbo.MDT_DS_SAFIR_SalesOrderReasonCategory |
| dbo.SA_SAFIR_Countries | dbo.MDT_DS_SAFIR_Countries |
| dbo.SA_SAFIR_TransportZones | dbo.MDT_DS_SAFIR_TransportZones |
| dbo.SA_SAFIR_RejectionReason | dbo.MDT_DS_SAFIR_RejectionReason |
| dbo.SA_SAFIR_ProductAssortment | dbo.MDT_DS_SAFIR_ProductAssortment |
| dbo.SA_SAFIR_PlantLocationDistinct | dbo.MDT_DS_SAFIR_PlantLocationDistinct |
| dbo.SA_SAFIR_BusinessUnit | dbo.MDT_DS_SAFIR_BusinessUnit |
| dbo.SA_SAFIR_ProductSKUBusinessUnit | dbo.MDT_DS_SAFIR_ProductSKUBusinessUnit |
| dbo.SA_SAFIR_PurchaseOrderType | dbo.MDT_DS_SAFIR_PurchaseOrderType |
| dbo.SA_SAFIR_EAN | dbo.MDT_DS_SAFIR_EAN |
| dbo.SA_SAFIR_SellInCondition | dbo.MDT_DS_SAFIR_SellInCondition |
| dbo.SA_SAFIR_TaxClassification | dbo.MDT_DS_SAFIR_TaxClassification |
| dbo.SA_SAFIR_CalendarKF | dbo.MDT_DS_SAFIR_CalendarKF |
| dbo.SA_SAFIR_ProductPromoGroup | dbo.MDT_DS_SAFIR_ProductPromoGroup |
| dbo.SA_SAFIR_CustomerInSystem | dbo.MDT_DS_SAFIR_CustomerInSystem |
| dbo.SA_SAFIR_RegionRF | dbo.MDT_DS_SAFIR_RegionRF |
9. Tables MDT to DWH¶
- Тип: Sequence Container
- Описание: Загрузка данных из MDT в DWH
- Цикличность: Foreach Loop Container (Filling MDT tables)
9.1 Execute usp_MDT_to_DWH¶
- Тип: Execute SQL Task
- Описание: Загрузка данных из MDT в DWH
- Процедура: etl.usp_MDT_to_DWH
- Параметры мэппинга данных:
- @Batch → User::Batch
- @DWH_Link_Name → User::DWH_Link_Name
- @DWH_DB_Name → User::DWH_DB_Name
- @MDT_Link_Name → User::MDT_Link_Name
- @MDT_DB_Name → User::MDT_DB_Name
- @TableName_Source → User::TableName_Source
- @TableName_Destination → User::TableName_Destination
Используемые объекты:
| TableName_Source |
|---|
| dbo.MDT_OUT_ProductCategory |
| dbo.MDT_OUT_ProductBrand |
| dbo.MDT_OUT_ProductBrandGroup |
| dbo.MDT_OUT_ProductFamily |
| dbo.MDT_OUT_ProductSubFamily |
| dbo.MDT_OUT_DistributionChannels |
| dbo.MDT_OUT_CustomerInUnit |
| dbo.MDT_OUT_CustomerInRegion |
| dbo.MDT_OUT_Company |
| dbo.MDT_OUT_SalesOrganizations |
| dbo.MDT_OUT_PlantType |
| dbo.MDT_OUT_Plant |
| dbo.MDT_OUT_PlantLocation |
| dbo.MDT_OUT_UnitsOfMeasure |
| dbo.MDT_OUT_ProductStorageConditions |
| dbo.MDT_OUT_ProductTemperatureConditions |
| dbo.MDT_OUT_ProductStatus |
| dbo.MDT_OUT_ProductType |
| dbo.MDT_OUT_ProductPromoGroup |
| dbo.MDT_OUT_ProductSKU |
| dbo.MDT_OUT_SalesDocTypeCategory |
| dbo.MDT_OUT_SalesDocType |
| dbo.MDT_OUT_DeliveryType |
| dbo.MDT_OUT_InvoiceType |
| dbo.MDT_OUT_Currencies |
| dbo.MDT_OUT_SalesOrderReasonCategory |
| dbo.MDT_OUT_SalesOrderReasonClass |
| dbo.MDT_OUT_SalesOrderReason |
| dbo.MDT_OUT_Countries |
| dbo.MDT_OUT_TransportZones |
| dbo.MDT_OUT_CustomerInGroup |
| dbo.MDT_OUT_CustomerInChain |
| dbo.MDT_OUT_CustomerInFormat |
| dbo.MDT_OUT_PickingCondition |
| dbo.MDT_OUT_CustomerInMacroRegion |
| dbo.MDT_OUT_CustomerIn |
| dbo.MDT_OUT_KPI_CFR |
| dbo.MDT_OUT_KPI_OSC |
| dbo.MDT_OUT_OrderStatus |
| dbo.MDT_OUT_TransportTemperatureMode |
| dbo.MDT_OUT_TransportTypeGroup |
| dbo.MDT_OUT_TransportType |
| dbo.MDT_OUT_RejectionReason |
| dbo.MDT_OUT_CalendarKF |
| dbo.MDT_OUT_ProductAssortment |
| dbo.MDT_OUT_PlantLocationDistinct |
| dbo.MDT_OUT_BusinessUnit |
| dbo.MDT_OUT_StockType |
| dbo.MDT_OUT_WarehouseStatus |
| dbo.MDT_OUT_WarehouseSubStatus |
| dbo.MDT_OUT_StockCalculationRules |
| dbo.MDT_OUT_ProductSKUBusinessUnit |
| dbo.MDT_OUT_PlantSalesOrganization |
| dbo.MDT_OUT_PurchaseOrderType |
| dbo.MDT_OUT_POSMBudgetType |
| dbo.MDT_OUT_POSMBudget |
| dbo.MDT_OUT_POSMCategory |
| dbo.MDT_OUT_POSM |
| dbo.MDT_OUT_EAN |
| dbo.MDT_OUT_CustomerIn_SCD |
| dbo.MDT_OUT_SellInConditionGroup |
| dbo.MDT_OUT_SellInCondition |
| dbo.MDT_OUT_TaxClassification |
| dbo.MDT_OUT_TaxClassification_History |
| dbo.MDT_OUT_CustomerInPriceList |
| dbo.MDT_OUT_CustomerInType |
| dbo.MDT_OUT_Constants |
| dbo.MDT_OUT_EmployeeTitle |
| dbo.MDT_OUT_WarehouseOperationType |
| dbo.MDT_OUT_WarehouseContractOperation |
| dbo.MDT_OUT_WarehouseContractTerms |
| dbo.MDT_OUT_FCUReasonCategory |
| dbo.MDT_OUT_FCUReason |
| dbo.MDT_OUT_ClosingStockFreeze |
| dbo.MDT_OUT_TDP_Scenario |
| dbo.MDT_OUT_ClaimStatus |
| dbo.MDT_OUT_LicType |
| dbo.MDT_OUT_TransportationEquipment |
| dbo.MDT_OUT_POSChain_ExceptWOS |
| dbo.MDT_OUT_CustomerInSystem |
| dbo.MDT_OUT_CustomerInSystem_Remapped |
| dbo.MDT_OUT_RegionRF |
| dbo.MDT_OUT_CustomerIn_Remapped |
| dbo.MDT_OUT_OrderPickingType |
| dbo.MDT_OUT_OrderPickingType_CustomerInRegion |
Список задействованных объектов¶
1. Базы данных¶
- DWH: KRAFT_DWH_CSL
- MDT: KRAFT_MDT_CSL
2. Внешние параметры¶
Запуск осуществляется с параметрами конфигурации внутри пакета, через переменные:
- DWH_DB_Name = KRAFT_DWH_CSL
- DWH_Link_Name = KRAFT_DWH_CSL_LINK
- DWH_LoginName = DWHSQLUser
- DWH_LoginPwd = ***
- DWH_ServerName = arrrumosapp17