Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do i improve performance of this fact table and this simple 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...- freeka
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
-
How to map this where clause in Oracle Warehouse Builder
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...- freeka
- Thread
- Replies: 0
- Forum: Data Warehousing/Big Data
-
Modelling problem faced by rookie on Telecoms system
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...- freeka
- Thread
- Replies: 3
- Forum: Data Warehousing/Big Data
