I use a few Teradata tables that are updated once a month, and the max date is always the first day of the previous month.
What is the syntax to select the max(load_dt) in Teradata?
I am using this code below and getting this error:
3149: TDWM Filter violation for query Request: For Rule Name 'HighStepRowsProdJoinLimit'
ACCT.WAE_PRD_DT in (select distinct max(ACCT.WAE_PRD_DT) from WAE_ACCT)
AND summ.wae_prd_dt in (select distinct max(summ.wae_prd_dt) from WAE_ACCT_SUMM)
AND CXA.EXPIR_DT in (select distinct max(CXA.EXPIR_DT) from WAE_CLIENT_X_ACCT)
and bdw.WAE_PRD_DT in (select distinct max(bdw.WAE_PRD_DT) from BDW_ACCT)