Search results for query: *

hi all I solved this. For those interested in knowing: I created bitmap indexes on the FK column in the fact table. There are UK indexes on the date value in the dimension table. I also created a bitmap join index as well just to be on the safe side but I think that was overkill. The query...

Hi there I have a FACT table called TRANSACTIONS_FACT which contains calculations on accounts such as amount_debited, amount_credited. I also have a DATE_DIMENSION table. In my TRANSACTIONS_FACT table, I have a FK link to the DATE_DIMENSION table via the column DATE_KEY. In the fact table...

Hi all I have a where clause which I am struggling to map in Oracle Warehouse Builder. Problem is that I don't know what mapping will cover the CASE clause I have. I know I could use Expression operator but where do I put it in reference to my mapping? Many thanks in advance. WHERE...

Hans Many thanks, it helps a lot. Truth is that no-one here knows exactly what a project like this entails. To make things worse, I have to trawl through Oracle 11i Apps schema in order to extract the data for the warehouse and then to use Oracle Warehouse Builder 10g in order to perform the...

Hi there I have been handed a DW project and I am struggling to implement the theories into practice. Here is the problem: Background ========== I work for a telecoms company that tracks the users of their mobile phones. Each account has multiple mobile phone numbers (MPN) and each MPN has...