ETL Architecture | tropically

Article on the "flaws of the classic dw architecture"

I hope this is not off topic, since it talks about architectures instead of a specific data modeling problem. A couple of months ago I read an article by Rick van der Lans by the title "The Flaws of the Classic Data Warehouse Architecture":

steps to design Data Architecture

Hi folks, I have been following this forum from past 6 months and it had helped me lot.I would like to thank you all and appreciate your time in discussing about various topics.AND THIS IS MY FIRST POST IN THE FORUM. I am in to data modeling from past

DW Architecture for a new setup

Ok I'm a newby to DW. I am tasked with setting up a data warehouse this year. There are a couple of things which I feel make it unique, I'll outline the plan I have come up with to accomplish this as of right now. We have 2 OLTP systems, one was from

Visual Analytics Architecture

Hi all, we are planning to build a new Visual Analytic tool. As we handle huge amounts of data, this is a very challenging assignment. I am looking for best practices of architecture for the data layer supporting this new tool. we have a very advance

data model architecture for economic forecast data

Hi All, I have to design data model for forecast data and I am a bit confused with how to go about it. The following are the two approaches I have taken for my task and would appreciate any help regarding this topic. There is one source file for each

Kimball Architecture in Oil and Gas industry

Hi Folks, Wondering if someone has implemented Kimball architecture in the oil and gas industry? Thanks,

ARM aims for the server room with its new 64-bit ARMv8 architecture

Hi, ARM aims for the server room with its new 64-bit ARMv8 architecture Chip design firm ARM today announced the eighth generation of its ARM Instruction Set Architecture (ISA). The ARMv8 ISA extends the current ARMv7 architecture to include

Multi - tenant or SaaS Warehouse architecture

Any material at all in the BI world on this ? Hi , We are planning to build a ware house on our Multi-tenant OLTP system. The challenges are first of its Multi-tenant and then since its multi-tenant it will be multi-currency, multi-language and mult

RETAIL BOOK SHOP FACT and AUTHOR dims

Modelling a Book shop chain - Dimensions - 1) Book ( Will have vendor details as attributes ) 2) Time 3) Store ------------------- A book can have mutliple authors and an author can write multiple books. I don't think FACT should have author

VIA announces Nano X2 E-Series CPU for embedded system

VIA Technologies has unveiled its new family of low power dual-core VIA Nano X2 series processors at the Embedded System Conference held recently in San Jose, CA. Available in 1.2GHz and 1.6GHz models, the new Nano X2 E-Series processors combine what Via

Enterprise Date Warehouse/Bus Architecture Physical Implementation

What is the best database design for EDW/Bus Architecture? creating all the dimensions (confirmed) in one oracle schema/sql server database and all the facts in another oracle schema/sql server database? OR creating all dimensions and facts in one

Loading Fact Table with Type 2 Slowly Changing Dimension

I'm new to data warehousing .. sorry if this is a basic question. I have a type 2 slowly changing dimension already loaded and now I want to load a fact table. At least, I think it should be a fact table. A lot of the entities in the dimension table

Fact table type

Basic questions about fact table type in kimball methodologies. Would appreciate if someone could explain 1)Transactional fact table type This is the transaction event captured from source OLTP system. Fact table in this case has all the keys instead