Hash Keys Clusters and Dimension Tables???

[wellster34]

Good Afternoon,

I have a situation for a requirement which I do not know if it can be done. I have been on google for hours trying to find a document/help on it so I thought I would give this a try.

If I have a Fact Source Table
i.e.
TABLE Account_Table
Account #
Date
Amount Due

We want to create a Time Dimension as follows:
TABLE Time_Dimension
YY
QTR
MTH
DATE

Now we need to create a Hash Key on DATE and MTH.

Then we need a PL/SQL process to take data from the Fact Source table Account_Table and process it by using the Date column to match up to the Time Dimension. We capture the Hash Key information and create a brand new table called i.e. Account_Table_Hash
Account #
Hash Key
Amount Due

Does this make sense or is this totally impossible. I'm new to these terms and type of processing and I'm having difficulty trying to understand them?

I have found off google that you can create a Hash Cluster and then Create a Table by refering to the Hash Key. So I believe I could create one for the time dimension... Now, I do not know if I create the 'new' Hash table Account_Table_Hash in the same cluster? How do I capture the Hash Key value to store in in the 'new' Hash table Account_Table_Hash???

If you know anything about this and have a link, please let me know. That would be greatly appreciated.

Thanks for you time.