Hi All,
we are currently analyzing our client data warehouse and we found few of the dimension tables are having only two columns (such as ID and DECSRIPTION)...while we are trying to remodel it ..is it a good idea to have the columns in the FACT table itself...
there are around 8 dimension tables and a FACt table..
There are arguments both ways. If you think you would ever have any kind of hierarchy in your dimension, or want to store pre-summarized data in your dimension table, keep it separate. Otherwise just put it in the fact table. You'll use up more storage, but you might get some performance, depending on how many rows are in your dimension table and how big the "description" column is.
Great...thanks for the info....
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.