EDW Design Decision
There is currently a difference of opinion on how the EDW should be structured for ad-hoc reporting. One camp suggests that the dimensional design can easily support both ad-hoc and analytical reporting. While the other suggests that the dimensional

PCB Layout Design Guide
Hi, Do you have a PCB Layout Design Guide for S5PC110? Regards, Howie

Fact table design: Sales Transaction with multiple Discount rows
Hi, I am designing a Sales DW where we can have multiple discounts on a given transaction line. I created a SalesTransaction (ST) fact table and a SalesDiscount (SD) fact table. In the current design the ST table has its own key that is a bigint

Transaction Fact design
hi I am faced with a problem designing a transaction fact in an investment firm. each transaction represents a trade the traders put in (buy,sale etc). The problem I am facing is: the metrics of a transaction change from one day to another day so a

The Design Forums - All about Skins/Themes, CSS & HTML
Forum Design - The Community of Web Designers Choice of the category: Computers and Internet Choice of a title: The Design Forums - The Community of Web Designers Forum address: http://www.thedesignforums.net/forum Main language: English Forum

Data mart design
Lets say I need to model Frauds. There is 2 departments handle different Frauds say (Contract and Health care). I am going to model this in MD (fact, dimension). Now should I just create one Fact table(Business Process) and use say Fraud type (Contract,

Slowly Changing Dimensions - Design Review (Need More Clarification)
Hello, Suppose I have following Fact and Dim table CustomerDim CustomerKey CustomerID CustomerNumber CustomerName CreditLimit - Slowly Changing, wants history IsAnnualMember - Slowly Changing, can be different from year to year or

Dimension Modeling Design challenge - Help Needed
Guys, Help me out identifying what’s 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

How to design student quarterly registration fact table
I am in the process of creating a student data warehouse for a university. I want to track the student quarterly registration. I am wondering what the best way to create the fact table is. The main dimensions should be time (quarter) and student but there

Kimballs design Tip#51 - Time Dimension
This tip suggests that we can eliminate the minute dimension and have a full time stamp in the fact row.I need more clarification on how this could be implemented. For instance if I need a fact to be shown with 1/2 hour split down how could I do it withou

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)
Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Common elements in web design layout
Creating a website design is not a simple process. You have to know many details related to web designing to give your websites the most perfect look. Web design layouts vary with respect to the requirements and preferences. Here are a few common

My Layout Design
I'm Planning to make a website , to show-off my graphics. Already made a Design (Layout) It's not 100% , it took me 3 hours work in Photoshop I Wanna see it !

Dimension Design
Hi I need some best design ideas for the scenario I'm sitting with. I have a Product Dimension consisting of standard attributes like Owner, Category, Brand, PackType , ProductId as natural key etc. The problem that I sit with is that the different

Fact table design - Showing something that did not occur
Hi everyone, I got a question about how to handle a situation with a user need. I have created a fact table factClassesStudentAttended. Those classes are for paramedic. The user wanted to know wich student took what classes and what was the