Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
22 tables about "Codes"
I am using it for end user reporting. You thought right at first place that I have 22 tables that have onle two columns: 1-Code 2-Descriprion But in each of these codes and descriptions there are thousands of records. So look like your solution will not work here. I was thinking to make a...- A3083131a
- Post #6
- Forum: Data Warehousing/Big Data
-
22 tables about "Codes"
@dkyrtata: Please correct me if I am wrong, basically you are saying that I should have a dimension table that will have 22 records in it. Every records will represent each Code table of the source. Have I understood you correctly?- A3083131a
- Post #4
- Forum: Data Warehousing/Big Data
-
22 tables about "Codes"
I have 22 tables with two fields (1- Codes, 2- Description) in each of them. I am building a star schema.Is it possible to make them dimensions around Fact? There will be 35 Fks all together in the fact. Or Make a junk dimension of all the Codes tables? How to do that then. Please advice Thanks- A3083131a
- Thread
- Replies: 6
- Forum: Data Warehousing/Big Data
