How much are your old records worth?

Techniques for Updating existing fact records

I have certain cases where I need to adjust the data in the fact tables due to late arrivers etc... I wanted to get peoples opinion on what techniques work best when you have to do updates to Fact rows i.e. overwrite, adjust but keep audit

How to handle Large dimensions 35M records

Hi all. I have a dimension with 35+ million records as compared to 225 Million in the fact table. I am not sure about the kind of penalty we will have to pay for such a big dimension. Here is summary regarding this dimension. This dimension is derive

Terrible animations- Not even worth looking at

LOOK HOW TERRIBLE I HAVE BECOME Let's get started. * - Good. * - Bad. * - Test. * - Long. Roll Test * Spoiler: Trails Test * Spoiler:

Elbow Unreleased debut album on island 1997 for sale on ebay

Hi guys just to let any of you know who are interested i am selling an original promo cd for the bands unreleased 10 track album from 1997 before they were dropped from island records, very very very rare piece of elbows history, so if your interested goo

How long should -1 dummy records exist in fact tables?

Dear Kimball Group, we are using the Kimball BUS Architecture method with SQL Server 2005, SSIS, SSAS, ProClarity, PPS, and MOSS. I am at a clients site that is using Full Refresh process for building 3 data marts so far every night. We are trying to

WORTH LOOKING INTO

Barclays Wealth Offers Deposit Sweep with Access to up to $10 Million in FDIC-Insurance 08 October 2009, New York This program offers clients the ability to invest significant amounts of their excess cash without compromising on the traditional

Little Fighter 2 World Records

It's copied from LF-Empire, but i also would like you to make new records. I would like to add a Topic where everyone can find the actual world records in Survival Stage.(Good to make this sticky) Here everyone can add his recording and tell what kind

The best PTC with minimum 20 ads daily each worth 0.01$

Is there any site that gives 20 ads daily each wiorth 0.01$ and payout not more than 10$

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

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Hedge Fund Industry Performance

[quote="batman"]December effect Bodes well for Hedge funds...I like this piece. Solid research...I also enjoy the 2010 outlook for funds... Hedge fund advisory firm the Hennessee Group believes the equity markets are likely to continue

Dinar Value (000's)and Exchange Rate Are Separate Events

Here’s something to consider…. The dropping of the zeros is just an in country occurrence …. It is completely irrelevant to an Iraqi what the exchange rate is compared to the dollar when he is buying a loaf of bread. Value is relative….. If an Iraqi

How to lookup a small group of records as one

Hi, I have source data which contains [Customer], [EventKey] and [ProcedureType], and the grain of this table is Procedure. [EventKey] is sometimes repeated, and this means there were many Procedures at one time. I need to fill a fact table that has