Hi I'm trying to do some ETL on some fields from previously two different tables. Both which are inner joined. That part works.
The trouble I'm having is with adding a preceding load on top of the new Fact table that was just inner joined. How can I add this pice to the main Opportunities fact table. What did I do wrong? adding field [dol_Contract_Value_Year1]