Fact table, strings and row size

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

Large Dimension table compared to fact table?

I may be misguided in my attempt to make a dimensional model here, but I will explain the scenario. We provide a value add service in the supply chain business...in this case by depicting a scorecard of the accuracy of vendors' product sizing

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

Dimension same size as Fact

I have a fact table designed to hold catalog information where the grain is defined as one row = one catalog item fact by warehouse by warehouse location in order to show warehouse inventories. One item may be in multiple warehouses, and in each the item

Fact Table Indexing Strategy

Please explain the indexing strategy which is in use in your organisation for fact tables in your current database(oracle, sybase, db2) Specify volume as the indexing strategy may be based upon the volume of data. Is there a well laid out strategy

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

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

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

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Questionnaire for medical record entries

Good afternoon, I am currently working on a data warehouse in the health care sector and I currently facing this problem: The aim of this warehouse is to have an overview of a cancer therapy. So, I have created the following fact table

Characteristics for a future evolution of the line ODROID

Hi, What characteristics do you think are necessary for the next revision? Thanks, Alvaro

Froyo Background Image Bug

The background images of applications seems to be rendered twice, the second one is in the child of the main linear layout. This happens after doing any touch event. Images are found below using an application I developed. Original: Bugged:

Sneak Peek - AOC Breeze

The AOC Breeze is a 8 inch tablet running Google's Android OS. Whilst the price tag might classify the Breeze as a budget segment tablet, its list of features says otherwise. With a USB2.0 port, Micro SDcard reader, 4GB internal memory, and WiFi b/g, this