Prepare query to load purchase order table

Requirement: Develop an SQL-based logic to display columns based on the field mappings provided in the attached tfs_mapping_purchase_order_abas 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.

 

Note

 

1. Use CTEs instead of temp views or subqueries in the main SQL only if needed
2. Any aggregation function should be handle in respsective CTEs.

 

Source tables are available in agilisium_playground.purgo_playground catalog