Target Database Table
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
To View Larger Image, Right Click and Choose Open Image In New Tab.
Calculated and Derived Fields
All content © Daasity 2021. Do not copy, share or distribute.