Gurudattap
Technical User
Hi,
We are in the design stage of a Banking DWH. In our proposed star schema , the FACT Table stores Account Balances and Customer is one of the DIMENSIONS around it. For a particular report, I want to fetch Cusomer Details for customers having Account Balance > Constant. In such a scenario, with Oracle database, what is the best way to put the query? Basically in this case, I am fetching "Dimension Attributes" based on "Fact Data in where condition" and not other way round (which would be our normal FACT/Balance queries).
Regards,
Gurudatta