How to consolidate numerous ETL processes?

c at 15h26
20
May
2010
How to consolidate numerous ETL processes?

Hi,

Within the department there are numerous users whose ETL processes are slightly identical to one another (e.g. an extra variable). This not only puts a burden on the server load, but also create problems where a certain measure is not identical across the department.

Therefore we're venturing down a new path to consolidate all ETL processes into one, which will eliminate the repetitive processes but most impo

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
(Text)book on core business processes
Can anyone recommend a good beginner's (text)book that explains a company's core business processes (such as sales, purchasing, marketing etc.) , associated activities, and supporting processes (such as accounting, HR). Thanks Uli
Business Process Identification, how low should you go?
How high level or low level should the first pass at business process identification and requirements gathering be? I had a discussion today with a business member, where they thought I had not identified their business processes properly, but I would
Disadvantage of Fact table with 44 columns
Hi all, First of all this question my be super easy for you guys but I am new with data warehousing. Our fact table, let name it SALES_FACT has 296 million rows and 44 columns. Out of 44 column 36 columns are foreign key values joined to diffrent
$ Al-Maliki: Link to Independent Bodies at the Council of Ministers is Natural and Legal $
Al-Maliki: Link to Independent Bodies at the Council of Ministers is Natural and Legal by mano: Date: Monday, 31-01-2011 12: 35 pm Baghdad (News) ...Prime Minister Nuri al-Maliki to link independent bodies at the Council of Ministers is a
Bus Matrix - Business Process -to- Source System not 1:1?
We have a number of source systems that all do the same thing- receive loan applications. The reason for multiple systems is because some are web-based, some are for B2B, and some are legacy. So, do we list three separate Business Processes on the Bus
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"How to consolidate numerous ETL processes?"

This topic has been viewed 1357 times.

Last message :
20/05/2010 at 15h26 by "c"