Need some help on a load script. I have 3 tables (items, batches, Searches). Items is a fact table, and the other two are hybrid fact/dim tables, all in QVD form. I have a where clause on Items, pulling only the last 28 days. How do I write a where clause on Batches and Notes that looks at the key and date from Items?
I am not only looking for existence of the value, but where the date >= Today()-28. Where would I define that part of the query?