Architecture questions : implement historical data view without SCD...

ETL Architecture

Hi My company is currently planning on building a datawarehouse. We are an oracle shop and are considering the approach for data migration from client servers to the datamart. Thoughts we have 1) Asynchronous CDC . I believe oracle now is replacing

Is An Historical Database Always a Data Warehouse?

Sorry, I posted this in the Resource forum but that was incorrect. Although I've been in Information Technology for decades, I have no experience (yet) with data warehousing. We have many operational databases. We have developed a need to store

Data Warehouse Questions

This year, were planning on creating a data warehouse and implementing an OLAP solution. From what Ive read on this site and others, I will be better off if the data warehouse is designed with a dimensional model. I have a few questions about the

How to implement a data warehousing solution for Google Analytics data?

I have click stream data such as referring url, top landing pages, top exit pages and metrics such as pageviews, number of visits, bounces all in Google Analytics. There is no database yet where all this information might be stored. I am required to

Staging > ODS > EDW

I have a basic query on Staging > ODS > EDW architecture. how the incremental data would be populated in EDW? Assume i have a "Customer Addess" Staging table which selects the delta from source system, then it updates the "Custome

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 model an event log

I am trying to model the following event data: Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie.

Assignment questions..

Hi.. Here are the questions below would request you to mailthe answers as soon as possible. 1.What is risk involved if derivatives are purchased without underlying commercial transaction? In 07-08 & 08-09 large number of Corporate lost thousands o

Top 10 Interview Questions 2 and 3: Strengths and Weaknesses

We asked a number of recruiters what the top questions were that they asked during interviews. We then compiled that list into the top ten interview questions. As part of our 10 part guide we will publish each question and the most appropriate way to

Live From The Brisbane 'HOLY SHIT IT'S COMING RIGHT FOR US' Flood Zone

Alright, just to keep you all up to date with things here. As some of you will know, I recently returned from a family trip to Europe for three weeks. The whole time, back in Australia, it rained. It rained and rained and rained some more. And the

Kirby's Epic Yarn!

So I got this today! Everybody with a soul enjoys some Kirby every now and then. This si Kirby's first console platformer game since Kirby 64 way back in 2000, I think it was. Time flies, eh? So here is what Sparky thinks of it: First off, Toys R' Us i

You're in the back of a police car with the person above you...

What four words do you say to them?

Architecture questions : implement historical data view without SCD?