1 Reply Latest reply: Dec 3, 2012 4:42 AM by jeneesh RSS

    Reg fact and dimension tabel loading

      Hi all,

      we have 2 dimension tabels and one fact tabel.

      is the below sequence is correct to load the tabels

      first one dimension tabel
      and next second dimension tabel
      and then fact.

        • 1. Re: Reg fact and dimension tabel loading
          Your question is vry generic, and you did not provide all the required information to make any comment.

          The normal practice is to load all the dimensions first - Normally dimensions wont have inter-dependancey.

          Load all the Fact tables - If there are dependencies, then according to that order.

          Laod all the aggrgate tables, based on the dependency..