using variables in the physical schema joins

[prabhak]

Has anyone tried using variables in the physical schema joins? 

[ZachBreimayer]

Hi Prabhak,

Please clarify with further detail on what you are trying to accomplish if I miss the mark here. It appears to me that you are simply trying to reduce the resultset. This may be ideal to simply add into the SQL scripts. Again, If that is the case and you face any challenges please clarify with further detail.

Regards,

Zach, Solutions Engineer

[prabhak]

Yes, i was trying to reduce the result set, trying to expose only the records that are active as of today (using CURRENT_DATE session variable). 

Dylan from Incorta has helped me understand this one - " The joins are calculated during loading time and cannot be dynamic (so can't use variables in the joins).