0 Replies Latest reply on Jul 31, 2012 5:06 AM by 728159

    Few dimension values used in FACT tables.

    728159
      Hello all,
      We are trying to know if somebody faced this issue earlier. We have dimension tables containing 5 million records, but the fact table uses hardly 30k of these dimension values. The fact table contains 350 million records, so is there any way to improve the performance of the query in such a scenario, where hardly 20% of dimension values are actually used by the FACT tables.

      Thanks and Regards,
      Upendra