1 2 Previous Next 16 Replies Latest reply on Jan 15, 2015 10:53 AM by tholkappian.vadivelu

    Can we get join culling to work if referential integrity is not enforced in the database?

    Prasanth Gopinath

      Can we get join culling to work if referential integrity is not enforced in the database?

       

      I have a data connection that is a simple star schema with a fact table and 10 associated dimension tables. Join culling does not seem to happen when using this data connection. i.e. even if I query for one column in a dimension, the query being sent joins all the 11 tables.

       

      We do not have RI enforced in the underlying Teradata database. Is there any way we can make the query use only the relevant tables being asked for in the report?

       

      Thanks

      Prasanth

        1 2 Previous Next