How do you handle Tv Films?

How to Handle Data that serves as both a dimension and attributes of another dimension

I have a invoicing warehouse with two fact tables. First is an invoice header fact table which reports on invoice totals and includes a surrogate key for a stat code that was assigned to the invoice. The grain is one row per invoice. Next is a part

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

How to handle the dialog box through the Selenium RC using C#?

Hi All, I am in process scripting using C# in Selenium RC for we application. While browsing the application I come across different dialog box e.g. dialog box with option Save and Cancel, window to select file to upload any file

ETL to handle deleted reference data

Hello all, I have a situation that I am unsure how to handle and would appreciate some input. My operational system allows me to add, edit and remove customers. My source operational system also constrains me from adding a cusomter with the same nam

Do you think my forumotion forum can handle about 200,000 members?

I am considering transferring my SMF forum members to my forumotion forum. I am just wondering can my forumotion forum contain 200,000 members or will the server be crashing like many others?

How to handle a Flame War situation.

Flame wars have been popping up a few times, while rare, if it does happen, this will teach you what and what not to do when in/discovering a Flame War. What to do on Pivetworld: 1. Try not to get involved. 2. Always log out if you sense a Flame

Determining a users dynamic id

Hi all I've read quite a few forum topics and I have always managed to stumble across something that will get my problem solved. But this time I'm going to register and sign in and write up a query. I'm a bit of a newbie and to testing in general,

How to play videos on your epad, m150 and panimage

You can use this link to learn how it's done. Link

How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)

Hello, Within Ralph his new book he describes recommanded situations for snowflaking a dimension. His example is a large customer (visitor) dimension. (page 337, 338 and figure 10-6). I find the artical good, but there is missing one part of this

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Null value for dates

All of my dimension tables have a value -1 that means there was no match to then dimension table. I try to put in some value such as "Unknown" or "Not available". Any suggestions for the -1 row in a Date dimension? Should I use some future date suc

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

People ganging up on others

What is the deal with jerks enjoying ganging up on somebody on some web sites?