This content has been marked as final. Show 4 replies
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?