Preparation of Order Pipeline for Array Version ‘beta’ only
Numbered Comparison Results:
1. ❌ DIFFERENT: busopp_dates.sql (20241120/svw_dev_flat\busopp_dates.sql | 20241120/svw_prd_flat\busopp_dates.sql)
2. ❌ DIFFERENT: busopp_details.sql (20241120/svw_dev_flat\busopp_details.sql | 20241120/svw_prd_flat\busopp_details.sql)
3. ❌ DIFFERENT: busopp_details_plus.sql (20241120/svw_dev_flat\busopp_details_plus.sql | 20241120/svw_prd_flat\busopp_details_plus.sql)
4. ❌ DIFFERENT: busopp_value.sql (20241120/svw_dev_flat\busopp_value.sql | 20241120/svw_prd_flat\busopp_value.sql)
5. ❌ DIFFERENT: customer_invoice.sql (20241120/svw_dev_flat\customer_invoice.sql | 20241120/svw_prd_flat\customer_invoice.sql)
6. ❌ DIFFERENT: customer_invoicestatus.sql (20241120/svw_dev_flat\customer_invoicestatus.sql | 20241120/svw_prd_flat\customer_invoicestatus.sql)
7. 🟠 MISSING IN PRD CONTAINER: customer_invoicestatus_202411.sql (20241120/svw_dev_flat\customer_invoicestatus_202411.sql)
8. ❌ DIFFERENT: customer_invoicevalue.sql (20241120/svw_dev_flat\customer_invoicevalue.sql | 20241120/svw_prd_flat\customer_invoicevalue.sql)
9. 🟠 MISSING IN PRD CONTAINER: customer_invoicevalue_202411.sql (20241120/svw_dev_flat\customer_invoicevalue_202411.sql)
10. 🟠 MISSING IN PRD CONTAINER: customer_invoice_202411.sql (20241120/svw_dev_flat\customer_invoice_202411.sql)
11. ❌ DIFFERENT: customer_order.sql (20241120/svw_dev_flat\customer_order.sql | 20241120/svw_prd_flat\customer_order.sql)
12. ❌ DIFFERENT: customer_orderline.sql (20241120/svw_dev_flat\customer_orderline.sql | 20241120/svw_prd_flat\customer_orderline.sql)
13. ❌ DIFFERENT: customer_orderlinestatus.sql (20241120/svw_dev_flat\customer_orderlinestatus.sql | 20241120/svw_prd_flat\customer_orderlinestatus.sql)
14. ❌ DIFFERENT: customer_orderlinevalue.sql (20241120/svw_dev_flat\customer_orderlinevalue.sql | 20241120/svw_prd_flat\customer_orderlinevalue.sql)
15. ❌ DIFFERENT: customer_orderstatus.sql (20241120/svw_dev_flat\customer_orderstatus.sql | 20241120/svw_prd_flat\customer_orderstatus.sql)
16. ❌ DIFFERENT: project_cost_CAD.sql (20241120/svw_dev_flat\project_cost_CAD.sql | 20241120/svw_prd_flat\project_cost_CAD.sql)
17. ❌ DIFFERENT: project_cost_USD.sql (20241120/svw_dev_flat\project_cost_USD.sql | 20241120/svw_prd_flat\project_cost_USD.sql)
18. ❌ DIFFERENT: project_details_plus_CAD.sql (20241120/svw_dev_flat\project_details_plus_CAD.sql | 20241120/svw_prd_flat\project_details_plus_CAD.sql)
19. ❌ DIFFERENT: project_details_plus_USD.sql (20241120/svw_dev_flat\project_details_plus_USD.sql | 20241120/svw_prd_flat\project_details_plus_USD.sql)
20. ❌ DIFFERENT: project_revenue_CAD.sql (20241120/svw_dev_flat\project_revenue_CAD.sql | 20241120/svw_prd_flat\project_revenue_CAD.sql)
21. ❌ DIFFERENT: project_value_CAD.sql (20241120/svw_dev_flat\project_value_CAD.sql | 20241120/svw_prd_flat\project_value_CAD.sql)
22. 🟠 MISSING IN PRD CONTAINER: project_value_USD.sql (20241120/svw_dev_flat\project_value_USD.sql)
Total number of different files: 18
Total number of missing files in DIR1: 0
Total number of missing files in DIR2: 4