Data Warehouse Modeling

Beginning Data Modeling for DW

Hello, Please bear with me as these are a beginner's struggle to implement the DW the best way possible. I recently started studying about Kimball modeling. I would like to ask a few questions on common practices on modeling the DW. I need to

Data Warehouse for survey data

Hi All, Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients).

Building data warehouse from scratch.. Need some advice.

Hi Folks, Currently my job is to build a data warehouse. Business is using crystal reports to generate reports from the production database(ODS). Now we want to build a data warehouse and use OBIEE OR COGNOS to generate the reports from the data

Banking Data Warehouse

Hi, I want to build a Enterprize Banking Data Model. So I want to know the basic conformed dimensions for the different subject areas of Loan Application, Payments, Customer contacts, Account Balances. Can you provide me with any documents or a standard

How to model Customer in data warehouse

Hi! I have a datawarehouse that contains facts for store sales (FactStoreSalesTransactionLine). I´m now about to create a new Fact for our order sales (internetorder, phoneorder etc). I have som questions regarding how to handle the customer (and

Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project

Hi One of my client has multiple source OLTP system (due to acquisition) which stores same type of data e.g. order, sales amount etc now they might be called by different name according to source system but they mean the same e.g. one might call is

Dimension Modeling Design challenge - Help Needed

Guys, Help me out identifying whats wrong with my model. I am able to get to the right data, but size of the fact table is arguably high and not gladly acceptable. Let me show you the picture (tip of the iceberg) Data table in transaction db is

2 sources using Dimensional Modeling Workbook

We are using Kimballs Generic Dimensional Modeling Workbook and it is really great! But now we have 2 sources to the same target and are not sure about how to document that. Anyone now about a best practice for how to document this in the Generic

Opportunity (Funnel) Modeling

I have some questions about a process that I'm modeling in my company and need some pointers. I've attended the Dimensional Modeling class and read the book, but I'm stumped about how to solve this problem. The business requirements for the

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

Joining two Fact tables???

I am having trouble joining two fact tables. I have read the different topics and see that the bridge table would be my logical option. The subject I have is Orders. I can place an Order which may contain many items...as well as, the items can be a par

Model Iklan

Yang tinggal di lembah Klang sahaja..... Saya memerlukan model iklan berumur dari 2 thn hingga 60 tahun untuk iklan TV. Rupa dan bangsa tak penting, yang penting anda smua berbakat dan ingin cabaran. Kenapa saya kata "Yang tinggal lembah Klang shj"

Vantage,Corel&C'ning,Akojaya Dll-Ansur & K2(sale %%%)

KEDAI SAYA ADA KOLEKSI..BARANGAN KEPERLUAN RMH .....& JUGA KEPERLUAN KAUM HAWA...(PN/CIK/ DATIN/PUN SRI ).......seperti.......... ~~PAD BERHERBA SUSEN ~~TUPPERWARE ~~KOLEKSI VANTAGE ~ KLASIK & PREMIER ~~KOLEKSI CORRELLE & CORNING WARE