| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What are the Different methods of loading Dimension tables
|
| June 06, 2005 07:41:43 |
#2 |
| Prabhu B |
Member Since: Visitor Total Comments: N/A |
RE: What are the Different methods of loading Dimension tables
|
Conventional Load:
Before loading the data, all the Table constraints will be checked against the data.
Direct load:(Faster Loading)
All the Constraints will be disabled. Data will be loaded directly.Later the data will be checked against the table constraints and the bad data won't be indexed. |
| |
Back To Question | |
