Staging > ODS > EDW

user2000 at 22h08
02
Sep
2009
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 "Customer Addess" ODS table.

how the incremental data would be fed from ODS to "Customer Addess" Dimension which is located in EDW with SCD policy?

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
back room design
I have a question. What is the difference between Relation database Design DW(3nf, like the source system) and create a data mart in star schema from that and Dimensional DW (back room the kitchen) and then start schema for presentation. Thanks
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
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
hackers took up staging
hackers took up staging post but unhealthy contents admin please delete Offers now I've lost the admin hackers have changed the registered mail and password Forum addresses were only into vulgar
Data Warehouse Questions
This year, we’re planning on creating a data warehouse and implementing an OLAP solution. From what I’ve 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
Forums from same category
Informations

3 Replies For the topic :
"Staging > ODS > EDW"

This topic has been viewed 2414 times.

Last message :
02/09/2009 at 22h08 by "user2000"