Results 1 to 2 of 2

Thread: Load Fact Table

  1. 08-28-2007 #1
    suneetharoy
    suneetharoy is offline
    Junior Member
    Join Date
    Jun 2007
    Answers
    5

    Load Fact Table

    I have 6 dimension tables. I loaded 5 dimension tables but with out loading reamining 1 dimension can i load fact? If so how?
    Can any one help me out with proper answer plzzz

    Reply With Quote Reply With Quote
  2. 09-03-2007 #2
    N SRIRAM K
    N SRIRAM K is offline
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: Load Fact Table

    In a star schema all the DIMENSIONS have referential integrity relation with FACT table. So you can't fill FACT with out filling all Dimensions which have RI relation with FACT.

    Thanks....

    Thx
    SRIRAM N
    Hope Everything Good
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact