PDA

View Full Version : degenerate dimensions



mondrian_jnicho02
07-16-2003, 03:20 AM
is it possible to specify a fact table column as a dimension without having a corresponding dimension table?

jhyde
07-17-2003, 08:39 PM
Indeed it is. Simply specify a dimension without a table and foreign key, and it is asumed to be in the fact table.
In the schema guide [http://apoptosis.dyndns.org:8080/open/mondrian/doc/schema.html], "Payment type" is an example of such a dimension.