Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tips to speed up performance when loading data warehouse

Status
Not open for further replies.
RonvdP

RonvdP

Programmer
Nov 3, 2006
3
0
0
NL
Who has got tips to increase the speed with which data is loaded in a data warehouse?
We are working in a DB2-environment mainframe.

Thanks
 
Sort by date Sort by votes
Would depend on the structure of the datawarehouse. The datavault architecture ( is especially equipped with fast and efficient loading.
More generally, dropping indices and refering RI during load would increase load times. I have no mainframe experience, so this may no apply..

Ties Blom
 
Upvote 0 Downvote
You may even wonder if RI should be enabled at all in your DWH. It should be taken care of by the only source of mutations: your ETL code.

As I don't have any experience on DB2 can not be of help here.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Sean C
  • Locked
  • Question
Building a data warehouse. Advice please?
Replies
0
Views
90
Sean C
Sean C
RJKumar
  • Locked
  • Question
How to build Dimensional model for commission received and return
Replies
1
Views
119
johnherman
johnherman
Ulianna
  • Locked
  • Question
Loading files from different sources into one database table
Replies
1
Views
65
johnherman
johnherman
analyst12
  • Locked
  • Question
JobControl (bfBCIExecSQL): SQL Error: SQL State = 08003, DBMS code = 0 [DataStage][SQL Client]Connec
Replies
0
Views
96
analyst12
analyst12
johnherman
  • Locked
  • News
Advice on Big Data projects
Replies
0
Views
79
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top