I'm currently in the process of building a warehouse to store transaction details based on a star schema design. The fact table will store balances down to the transaction grain, and there will be a transaction dimension to store transaction attributes, e.g. account number, deal ref etc.
One of the transaction attributes is a flag to indicate whether the> balance is an assest or liability. I'm reluctant to make the transaction dimension a type 2 SCD, but will have no choice if the flag is stored in the dimension table.
Is it OK to make the flag a fact?
Dig Deeper on Oracle data warehousing
Related Q&A from Ian Abramson
A SearchOracle.com member asks why a low-cost query has a slower speed than expected. Continue Reading
We are working on the development of a datamart (in 9i) which takes data from two source systems. Since this is a transaction system, there is a lot ... Continue Reading
I am new to Oracle's ETL tool and I need information on data migration using Oracle ETL. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.