What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Different methods of loading data as PDF --


 

There are two different ways to load data in dimension tables.

  • Conventional Load (Slow)
  • Direct Load (Fast)

Conventional Load (Slow)
All the constraints and keys are validated against the data before, it is loaded, in this way data integrity is maintained.
Direct Load (Fast)
All the constraints and keys are disabled before the data is loaded. Once the data is loaded, it is validated against all the constraints and keys. If data is found invalid or dirty it is not included in index and all future processes are skipped on this data.

 

 

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*