I am trying to design a data warehouse and been reading Kimball's Data Warehouse Toolkit. It says that the no of foreign keys should not exceed then 20.
When i looked into my relational database and started designing as per Kimball's design i found out that there are going to be over 60 foreign keys. Hence i thought to ask you guys help.
For example one of my table has got the addresskey and index of 0-9, for index 0 it means pick up address, for address 1 it means drop off address, for index 2 its firs stop over. Now in DW am i right in assuming that i have to treat them as a separate column and each address and stop over will have its own key? meaning that 10 foreign keys for addresses only. There's another table called reference with similar columns.
I would really appreciate your help here on how to handle this scenario?
If I put this as a project how much is it going to cost approx?