Dimensional update but no new facts

Textual Facts in the fact table

Its a new financial 'capital markets' dimensional reporting model (for IPO - raise money for an issuer by issuing new equity common stock securities) that's in design stage. There are some textual attributes of the grain of several fact tables for which

Facts or Dimension Attributes?

My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th

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).

Modeling for Service related facts and dimension (for Tour Operating Company)

I am currently doing a dimensional model design for a Tour operating company. Their business is like selling hotels rooms, flights, and excursion to customers. All these are called SERVICES. Now I am designing dimension and fact table to hold bookings

Modelling help for multiple level facts

We have an Expense application which has an Expense Header, Expense Details and Expense GL Transactions. I need some help on the design. All 3 tables contain fact and dimension data. The issue I have is in relating the 3 fact tables. On the Dimension

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

Have You Scrutinized The Facts About Juicing, Healthy Diet, Juicing For Better Health

By David Wellsford We are all very aware today the benefits of good nutrition, and the vitamins, and minerals that are necessary for our health. What do we know about juicing, healthy diet, juicing for better health? What does juicing mean? Making

16 Amazing Science Facts

1. Fingernails grow four times faster than toenails 2. Right handed people live, on average, nine years longer than left-handed people 3. If you rub an onion on your foot within 30 60 minutes you will be able to taste it this is because it

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it 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

NEW UPDATE : Forumotion Traffic exchange!

Dear users and members, To improve the ranking and the audience of your forum, we inform you that we have now added a new feature entitled "Traffic exchange" which remains in Beta. This new option will allow you to share traffic and

Daisy Owl Official Discussion

"You fear go into those forums. You know what they awoke in the darkness of Treehouse 2.0. Admins and flame!"

PanImage Media Tablet 7" Touchscreen Google Android WiFi Multimedia for $129.95 free shipping at QVC

This is just like Maylong M-150 and Flytouch/ePads with 24-pin connector Price shown on QVC is $153.99 too much money for these. It only cost in China $60 bucks! This one can use the latest Tablet Zone Tz21111c ROM MOD. Take multimedia to the