Correct Tables Relationship

Fri, 09 Aug 2013 18:50:54 GMT

I have 2 tables, where one has the following description:

Groups:

CODE_GROUP

DESC_GROUP

And the fact table with these columns:

FactTable:

...

CODE_GROUP_1

CODE_GROUP_2

CODE_GROUP_3

CODE_GROUP_4

CODE_GROUP_5

What's better way to relate the five columns of the table FactTable with the table Groups? (Considering the Star Schema)

Best Regards.

Re: Correct Tables Relationship

Oleg_Troyansky — Sat, 10 Aug 2013 00:04:37 GMT

Well, you have three choices:

1. Load the dimension table 5 times and associate each Code with the corresponding Dimension, or

2. Join the 5 Descriptions into the Fact table and add 5 Description fields to your Fact, or

3. Further normalize your fact table and create a seaprate relation table that connects the Fact rows to their Corresponding Code Groups (in your example, 5 rows per each Fact row).

Finding the best solution out of the threee would be a tough choice, driven by your business needs, the actual meaning of the 5 Groups, the size of your Fact table and the size of your Dimensional Tables.

For example, if your business requirement is to have a single field on the screen called "Group Description, then option 3 is probably your best choice. If, on the other hand, you need the 5 Group Descriptions in separate list boxes, then your choices are probably between 1 and two, depending on the data size.

good luck with your choices!

Oelg Troyansky

topic Correct Tables Relationship in QlikView

Correct Tables Relationship

Re: Correct Tables Relationship