ETL Load - Dropping Indexes and Constraints

AzeemFarooqui at 13h32
03
Mar
2009
ETL Load - Dropping Indexes and Constraints

Hi,

I am currently working on an ETL solution using BODI and SQL Server 2005. Our data warehouse is very small (no more than 5mb) currently and expected growth over the next year is not going to exceed 15mb.

Based on the above volume estimates does it make sense to drop existing indexes/constraints when performing the ETL load into the fact table?

I'd appreciate other peoples comments and views on

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
Foreign Key Constraints
Hi What is the norm in data warehouses when implementing FK constraints, is it beneficial to create them or not have them at all (SQL Server 2008) Regards Tim
Data Warehouse - Indexes
Hi, I am currently at the point where I need to think about Indexes on my data warehouse. We are currently using SQL Server 2005. As a general rule of thumb would the following hold true (Please note that the reporting requirements are still
Best Practice For Indexes
Many books have very different opinions on what indexes you should create for a typical star schema having the following generic structure: Fact table fact_surrogate_key dim1_sk dim2_sk dim2_bk (business key -- assuming hybrid type 2 scd, joins bot
Multivalued Dimension, bridge table, and constraints using SQL Server 2005
I'm developing a healthcare claims data mart. The diagnoses fields in the claims data are being implemented as a multivalued dimension, which consequently requires a bridge table between FactClaims and DimDiagnosis. The bridge table contains two
save/load money glitch
If you save and reload then you gain that save file's money. If you save while reloading over and over you can double your money. I currently have 94956019 Gold, 2 girls, day 1, and one house. this is my second playthrough of the game and I kept my gold
Forums from same category
See also
more_less
Informations

5 Replies For the topic :
"ETL Load - Dropping Indexes and Constraints"

This topic has been viewed 2343 times.

Last message :
03/03/2009 at 13h32 by "AzeemFarooqui"