Populate a new logic in view d_product

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: Prepare SQL to populate add a column hfm_entity

 

 in a view d_product_vw  and populate the value by  joining edp_lkup and d_product and populate lkkup_val_01  only for src_sys_cd as orafin. For the other src_sys_cd hfm_entity will not change.

 

Joining condition : edu_lkup. lkup_key_01 = d_product .stock_type

 

 

 

 

 

 

 

Unity Catalog Information:edp_lkup, d_product_vw  , d_product