What are the different methods ot loading a dimension table? a fact table etc?
Posted On: Jun 16, 2021
The different methods of loading a dimension table and fact table are:
- 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.
The fact table is normally loaded from transaction tables such as order tables or from transactional files, such as web logs.
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
Teradata Interview Questions
Explain Teradata utilities. What is MultiLoad , Fast Load, Tpump ?
Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time. FastLoad can sort the incoming rows directly into the target table. MultiLoad first...
Teradata Interview Questions
When do you use each of these? Why? Explain in detail.
It is used because Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time....
Teradata Interview Questions
Explain Teradata Architecture in detail .
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET, and Access Module Processors (AMPs)....