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
Printable View
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
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....