Load f_intry_bal_dly_trf table

Requirement: Develop an SQL-based logic to display the columns based on the field mappings provided in the attached trf_mapping_inv_bal XLS file.

 

_The excel file mainly includes:_

 

1. Data_map – This file contains the source-to-target mapping for the target fields
2. Source_tables - this sheet contains the name of source tables, filter conditions and the special notes.
3. Joins – This tab defines the joining conditions and type of joins between source tables.

 

Acceptance Criteria:

 

1. Use CTEs instead of temp views or subqueries in the main SQL.
2. Any aggregation function will handle in respsective CTEs.
3. Primary Keys to handle the duplicates are prod_plant_lot_location_key and capture_dt_yyyymmdd