A table is determined to be a fact, dimension, or outrigger table, based on its dimensional modeling role. By default, a role is assigned to the table based on the relationships drawn to other tables. A table with no relationships is considered to be a dimension table. When you draw a relationship from one table to another, it is determined if the child table in the new relationship acts as a parent in any other relationship. Based on this information, the following rules are used to assign dimensional modeling roles:
You can override a role assignment on a table-by-table basis in the Dimensional tab of the Tables editor.
Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |