Need to join dimension tables

Dimension Tables as lookup tables

Recently one of the developers at my organization approached me and asked that I take a table that exists in one of our source systems and put it in the DW, so that he could populate a drop down and validate data for the web app he was developing. ie,

Monster dimension, joining fact tables

I am newbie to the DW. We have document processing OLTP system with the following tables Document table (partitioned table, approx. 1 billion rows) DocId -PK Title DocDate 10 other columns Users table UserId -PK UserName .. 3 other

Building aggregate fact tables from staging

Hi, Is it acceptable to create an aggregate fact table from the staging tables after you have cleaned out the data in staging? I know usually you're supposed to create aggregate fact tables from the fact/dimension tables, however can it be done straigh

Snapshot Dimension & Fact tables

We are currently designing a logical multidimensional model from an OLTP tables.Dimension tables have monthly snapshot because some of or all the attributes might change on monthly basis.The same situation for the fact table has monthly snapshot. I kno

use of degenerate dimension to physically join two logically related fact tables

I am looking for a sanity check on a design decision. Here is the scenario: The business domain is insurance, specifically life and annuity. I have two fact tables - factPolicyTransaction and factCommissionTransaction. Policy transactions,

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

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

JOIN TERUS DAPAT CEK

Rakan-rakan internet Semoga anda semua ceria dan bahagia Sekarang terlalu banyak program yang mengajak kita menjana pendapatan dengan pendapaftaran yg serendah RM10.00 sahaja HINGGALAH yang besar termasuk juga program MLM dsbnya. .... CERITA SEBENA

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

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

The Character Thread

Alright, let's try out the RPG forum. I'll run a game (because I would end up being the only one who wants to anyway) Everyone who wants to play give me characters, and once I have enough I'll start a game over in the RPG:Do forum

Tranformice Tribe Forum

Since we have one for TDP4, why no transformice. I nominate Zephyr, Stephen, and one non -staff member(of their choice) to lead it. Again, just suggestions there, but IMHO their the best for the job.

Post your Omegle/IM/EMAIL chats.

Note- Omegle is a website where you can chat with strangers over a safe and non-invasive chatbox. Post any conversations you have that are post-worthy from either Omegle, Instant Messaging or Email~ Warning - Omegle is uncensored and thus anything