Reasons to use a 3NF design over a Dimensional Model design for an ...

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,

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

Design to calculate CHURN (movement of employees between business units)

All, I am working on a HR Analytics datawarehouse and I need to design (ETL and Data Model) a way to capture what is called "churn". Currently, my DW has the following: Workforce Event Fact, Cost Center Dimension, Cost Center Dimension

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

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

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

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

SET1/Q.2 a. What are the needs and characteristics of a good research design?

Q.2 a. What are the needs and characteristics of a good research design? [5 marks] b. Highlight the merits and demerits of primary data collection methods. [5 marks]

SET2/ Q 3. What are the characteristics of a good research design?

Q 3. What are the characteristics of a good research design? Explain how the research design for exploratory studies is different from the research design for descriptive and diagnostic studies.( 10 marks).

RP Basketball...The Road Back To World Championship 2010

Yeng Guiao is the best to coach the next National team, I hope he will include these players: the best line-up for me: Lordy Tugade James Yap Gabe Norwood Anthony Washington Kelly Williams Jared Dillinger Jimmy Alapag Jay-jay Helterbrand Asi

Married Man reasons why still getting PSP or MPA etc

i'd like to hear this from most of us here let me start with this, i'm married and i love my wife and daughter as joey doc says they are my priority, and as joey said the best thing to win temptation is to submit to it, though half agreed ako dito since w

General EB Discussion - Ongoing

Please feel free to keep a rolling discussion in here : )

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion