ETL Architecture

tropically at 17h04
05
Feb
2010
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 this with Golden Gate.
2) Export / Import
3) Db Links
4) Oracle data pump. (Similar to export / import)

Questions
Anyone have any other option. Not su

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
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
Architecture questions : implement historical data view without SCD?
Hello ! I need some fresh points of view of an architecture I’ve just encountered. This solution was designed by a consulting firm specialized in the HR IT field. The DWH in this case is supposed to handle 100’000 employees for an organization of
ETL Architecture and Control Flow
Hi Folks, I am new to the forums, they look like an interesting place to discuss BI issues and troubles. So, I am not new to BI, but we have done a lot of re-architecting of the etl systems with servers being moved, wan considerations
Need help with terminology
Hello all, I have tried to depict my current dw schema in the image below. As you can see the transaction table, summary tables are all part of the same physical schema. The transaction table has all the transactions since inception and has all the
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
Forums from same category
See also
more_less
Informations

2 Replies For the topic :
"ETL Architecture"

This topic has been viewed 2626 times.

Last message :
05/02/2010 at 17h04 by "tropically"