3530_PFT_BAS_performance_benchmark_history Transformation

Target Database Table

performance_trend_benchmark_history.

Script Description and Logic

Pulls a snapshot of performance_trends_benchmark at the daily level. Performance trend id and metrics from performance_trends_benchmarks are included and reported by unique performance id, shop id and date. From the performance_trends_benchmark table, lookup is made to pull the results for the previous day. The code performs a check to see if a daily snapshot of performance trends was loaded, if no performance trend id for today exist then all records not in the final table are recorded by way of insertion from the query into drp.performance_trend_benchmark_history.

Source Tables Used In Script

Coming soon.

SQL Flow

To View Larger Image, Right Click and Choose Open Image In New Tab.

 3530_PFT_BAS_performance_benchmark_history Transformation

Calculated and Derived Fields

Coming soon.


All content © Daasity 2021. Do not copy, share or distribute.