This discussion is archived
1 Reply Latest reply: Dec 3, 2012 2:42 AM by jeneesh RSS

Reg fact and dimension tabel loading

958705 Newbie
Currently Being Moderated
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
    jeneesh Guru
    Currently Being Moderated
    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..


  • Correct Answers - 10 points
  • Helpful Answers - 5 points