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
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....
Thx
SRIRAM N
Hope Everything Good