It's all about the answers!

Ask a question

Does full ODS job mean full Data Mart job?

Ryan Boyce (3112) | asked Jul 16 '17, 2:42 p.m.

 We inadvertently ran a full load ODS DCC ETL job this weekend. Once that job completes, would it be advisable to run a full load job on the Data Mart? 


One answer

permanent link
Francesco Chiossi (5.7k11119) | answered Jul 18 '17, 4:19 a.m.

Hello Ryan,

most of the jobs in the data mart section collect metrics for the current day, so they are not affected by the delta / full setting.
Other jobs in the section, like timesheets are affected like those in the ODS.

As a general rule, unless you have specific issues you want to fix, a full load is not required; even in this case where you run already the full load for the ODS part.

Best Regards
Francesco Chiossi

Your answer

Register or to post your answer.