What you are doing now, namely "...at the same time I insert all attributes of that load in the dimension table" doesn't sound right. Dimension tables should not be used like this. Study a few sample star-schemas in "text book cases", you will figure out the right way in designing your dimension...
Hi!
How do you define a Excel file as PB ODBC Data source
and see it as a table?
I tried it and could connect, but no table shows in
DB Painter.
When I selected the check box to "Show System Tables",
my Excel file "test_sony_1.xls" became "sony_1$", but
when I try...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.