best practice for daily query fetch date

Reply
Frequent Contributor
Posts: 83

best practice for daily query fetch date

hi,

 

I'm setting up daily automated reporting. Each morning, the job is set to query our tables for date: two days minus today (there is a two-day lag with the table refresh).  An approach is to write: where table_date=today()-2;.

 

If there is a better way (or if the above should be avoided), pls let me know. Currenly engine we use is Netezza, or Hadoop.

 

thank you 

Regular Contributor
Posts: 229

Re: best practice for daily query fetch date

I might be better if done in netezza as where table_date=current_date-2 and create a work sas table and then run the report on it

Ask a Question
Discussion stats
  • 1 reply
  • 77 views
  • 3 likes
  • 2 in conversation