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!
Some one asked me these
- Thread starter vani65
- Start date
A conformed dimension is one that can be applied to more than one datamart.
If you imagine datamarts as building blocks of a datawarehouse then conformed dimensions (i.e. those that "conform" to naming, definition and other corporate standards) will enable you to consolidate the data marts into an overall warehouse
To weight a table in Business Objects, you must be in Designer, in the schema window, then right click on a table and the context menu pops up. The Item 'Nummber of Rows in Table...' should be selected. Then you can use the physical number from the table or apply your own number to give a "weight" to the table
If you imagine datamarts as building blocks of a datawarehouse then conformed dimensions (i.e. those that "conform" to naming, definition and other corporate standards) will enable you to consolidate the data marts into an overall warehouse
To weight a table in Business Objects, you must be in Designer, in the schema window, then right click on a table and the context menu pops up. The Item 'Nummber of Rows in Table...' should be selected. Then you can use the physical number from the table or apply your own number to give a "weight" to the table
- Thread starter
- #3
See this thread:
What it does is orders the tables in the from clause from largest to smallest.
The time you want to use manual counts is if you know that the largest to smallest is not optimal.
The reality is that table weights don't really matter much for most databases. The only one I know of is Oracle with the Rule optimizer.
As for conformed dimensions, you should do some reading on data warehousing concepts. Try any book by Ralph Kimball or Bill Inmon.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
What it does is orders the tables in the from clause from largest to smallest.
The time you want to use manual counts is if you know that the largest to smallest is not optimal.
The reality is that table weights don't really matter much for most databases. The only one I know of is Oracle with the Rule optimizer.
As for conformed dimensions, you should do some reading on data warehousing concepts. Try any book by Ralph Kimball or Bill Inmon.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question