Initial stage tables from multiple sources?

Modeling a fact with multiple sources

We have a situation where multiple business processes will generate a recommendation. A recommendation is a set of instructions, estimated costs, risk analysis, etc. for identified hazards. Examples of various business processes that generate these

Does it belong in the stage tables or fact tables?

If I have a fact table with a "counter" fact, for example a customer places an order, but then goes back and changes parts of that order any number of times, I want to store how many times the customer changed his/her order. The grain of the

A dozen systems with many dimension codes

Hi, I have more than a dozen systems to integrate, and each has it's own version of dimension codes. The source systems need to use dummy codes, and multiple codes for one entity. This for operational reasons. So, to conform a dimension I have a

Stage Table for Fact Data

Is it a best practice to truncate a stage table before every load? --- RPC

Dimension loading sources

Hi all, It's about datawarehouse dimension loading : should i load dimension from a master data management referential or from the truth of my business application. In the first case, dimension will be cleaner than in the second case but it will not

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

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

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

How to manage multiple languages

Hi there! I have been using Media Companion quite successfully to manage my movie collection. However, I am having some problems managing non-english movies. I have several Italian language movies (in a separate directory from the English movies). In

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

Multiple Memberships IP Warning system.

Most sites have a ip scanner system on them that will flag up the members that have the same ip address and tell the admin's the ip and the names of the users. Right now the only way to see the ip and the ones that have more then one account is when th

Multiple Theme/Skin Selection 4 Members

There are some forums that allow you to use more then one template, the user can choose which look they want, we should do that with our sites!

Announcements and Sticky topics in seperate tables!

Yep, according to the topic /other-problems-f46/possible-t76511.htm it isn't possible to split global announcements and stickies in a seperate table. I'm suggesting for this to be possible! I hate it when the forums are so messed up! I'm sure the