Fact Table Indexing Strategy

Please explain the indexing strategy which is in use in your organisation for fact tables in your current database(oracle, sybase, db2)

Specify volume as the indexing strategy may be based upon the volume of data.

Is there a well laid out strategy for Indexing for fact tables?

If so, what is it we follow for Fact Tables in Oracle?
and
If so, what is it we follow for Fact Tables in Sybase?
and
If so, what is it we follow for Fact Tables in Db2?

The star transformation is the best strategy to follow :
http://download.oracle.com/docs/cd/E11882_01/server.112/e10810/schemas.htm#CIHGHEFB

You seem to have this idea that there is a one size fits all solution. Unfortunately, this is not the case. Yes, you should index. Yes, you should partition. Beyond that the rest is dependent on what you are trying to accomplish.