Populate product plant table using Data Mapping xls
Requirement
Introduction: Product table is typically used to manage and organize information related to the products being handled. This table can include various attributes to track products throughout the supply chain.
The product table is joined with other tables such as orders, suppliers, and inventory levels for comprehensive supply chain management.
Analyzing data from the product table can help in forecasting demand, managing inventory effectively, and optimizing the supply chain.
Requirement: Develop an SQL logic to display the d_product_plant based on the data _map excel file._
_The excel file has 3 sheets:_
_1.Data_map- This file has source to target mapping._
2.Source - contains source table along with filter and special handling at the table if needed
3.joins-This tab contains the joining conditioned joining type.
Unity catalog information:”purgo_playground.itemwopd", ”purgo_playground.itemledgerentrieswopd"
Expected output: Databricks SQL query[^d_product_plantdata_map_.xlsx]