Free form text in transaction table

Modelling free text comments

Hi all, I have a free text comment field that the business requires but I'm not sure what the best way to model this in my star schema would be, so just looking for a bit of advice. I have included my current star schema here: I am modelling

character data in a fact table?

I just changed companies. i was accustomed to pure star schemas with fact tables containing only foreign keys to dimension tables and number measures that could be aggregated (sum, average, min, max). At my new job, I find dims with foreign keys

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

Guidelines for FACT Table Design for High-Transaction Volume and High # of Measures ...

Hi All - This inquiry could actually be two questions, but the requirement is really presentation of row-wise high volume transactional data in a column-wise (columnar) FACT table. Here is a sample transactional data set: Interval Date TimeUni

Forum proposal

Category of choice: Games and RPG Introduction title: Saga, Free form and plotted RPG forum The main language: English What's it all about: It is a forum for written RPGs. They can have a plot for people to join or they can have a free form rpg.

Two ways of Changing Android Keyboard on Samsung Fascinate

Method 1. To Change Android Keyboard on Samsung Fascinate Step 1. Tap the applications launcher on your Samsung Fascinate. Step 2. Scroll over and select Settings. Step 3. In the settings menu, select Language & keyboard. Step 4. Select Input

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Energizer gives free hearing aid batteries

MANILA, Philippines - Energizer, maker of the world’s longest-lasting battery in high-tech devices, recently launched a public service program that gives out free hearing aid batteries to interested participants. With its long-standing commitment to

copyright free photos

http://www.prometheanplanet.com/uk/server/show/ConWebDoc.4476 Copyright made clear : Resources : Promethean Planet UK http://www.behold.cc/ Behold | Search High Quality Flickr Images Best quality images on Flickr - that are - free to use - modify - or

NEW RPG: The SQUIRTLES THE F^&*%e^% SQUIRTLES!

(Jt) JT stepped out onto the red martian surface, his ninja boots sinking only slightly into the rusty dirt, gravity having even less bearing on him than on earth. He breathed in deeply the nonexistant air, being that ninjas can breathe in space, and

BlazBlue: Continuum Shift

uhh yeah making BB thread new info for game to come soon!!

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