Tag: enterprise content management

Yes, as long as the granularity is the same

No, different facts should be stored in different tables

Depends on individual measure

Can't say

As long as the aggregate facts refer to keys in appropriate layer in the dimsension

Multiple aggregate levels can be stored in different tables

Aggregated facts should not be stored in the physical tables, they must always be calculated on the fly

A and B

All of the above

Having a single SQL query with FACT A, FACT B and Conf D.

Have a individual query between FACT A & Conf D, and a individual query between FACT B & Conf D.

Have three individual queries, one for each table.

A and B

All of the above

Additive Fact

Semi Additive Fact

Non Additve Fact

None of the above

Transaction

Periodic Snapshot

Accumulating Snapshot

None of the above

Both are measures

Order count is the measure, Team Size is the dimension

Team size is the measure, Order Count is the measure

None of the above

True

False

an attribute of a fact which quailifies as a dimension

stored in the fact table

has no surrogate keys

has fixed values that cannot be generated outside the fact

Increased sales

Improved product flow through

Total Automation of process

Lower total costs of ownership

Enhanced flexibility

Only A and B

Only B and C

only A and C

Only A and D