Load PO table

Requirement: Develop an SQL-based logic to display all the columns based on the field mappings provided in the attached trf_mapping_purchase_order 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 if needed.
2. Any aggregation function will handle in respsective CTEs.
3. Primary Keys to handle the duplicates are po_delivery_key

 

Raw tables are available in purgo_playground catalog