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!
Search results for query: *
- Users: krishnaa279
- Order by date
-
How can I create a dimension using multiple dimension at same level?
I don't think you are talking about a dimension table rather it appears as fact table. Best way to handle is build every thing in a single dimension and as every record is associated with a surrogate key you can get the values with group by clause. and creating sub dimensions is allowing...- krishnaa279
- Post #2
- Forum: ODBC/OLAP
-
Banking Data Mart - Case studies, issues
Hi nchapman, continuation for your posting...... you take the balances and running balances as measures in the fact and while retrieving multiply them with the wieghting factor. For hetrogeneous products if the measures are different(obviously the measures will be different) you create a fact...- krishnaa279
- Post #3
- Forum: Data Warehousing/Big Data
-
Banking Data Mart - Case studies, issues
Hi nchapman, To cope up with joint accounts you link the customer dimension with account dimension which will act as a bridge table between the customer and the fact table and take a field wieghtage. and the mechanism is if the account type is single wieghtage factor is 1 if in joint account...- krishnaa279
- Post #2
- Forum: Data Warehousing/Big Data
