What are the different methods ot loading a dimension table? a fact table etc?

devquora
devquora

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

    Please Login or Register to leave a response.

    Related 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)....