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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ngthompson
-
duplicating fields on both dimension and fact table.
Hans63 and johnherman thank you both so much for your responses. The fact table in question contains loan balance information -- the grain is 1 record per loan per month. The large dimension in question is a loan attribute dimension and contains 1 record per loan. Hans63, I misspoke when I...- ngthompson
- Post #4
- Forum: Data Warehousing/Big Data
-
duplicating fields on both dimension and fact table.
Hi all, Is it a bad idea to have the same field on both a dimension and fact table? Here's my scenario: I have about 10 descriptive numeric fields that reside on a dimension table. While the fields are numeric they are truly descriptive and rarely change and so they are dimension attributes...- ngthompson
- Thread
- Replies: 4
- Forum: Data Warehousing/Big Data
