Write the two ways of loading a Dimensional Table?
devquora
Posted On: Feb 22, 2018
The two ways of loading a Dimensional Table are written below:
- The first is a Conventional (Slow) method – Before the data gets loaded, all the keys and constraints are validated against it. Data integrity is maintained this way.
- The second is a Direct (Fast) way – Before the data gets loaded, all the constraints and keys are disabled. Data is validated against all the constraints and keys once it is loaded.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
MDM Interview Questions
What do you understand about MDM?
MDM is a methodology of allowing an organization to link all of its important data to one file, which is called a master file. This file provides a common base of reference. When implemented properly,...
MDM Interview Questions
How popular is MDM across the people associated with different fields?
People associated with IT and Computers get the concept easily. Business official understands MDM but not up to the level of former because businessmen are more interested in only knowing what benefit...
MDM Interview Questions
Tell us something about Dimensional Modelling.
Dimensional Modelling has two types of tables which is distinct from the third normal form. Here, Facts table containing the measurements of the business and Dimension table containing the context viz...