What are dimensions, facts?

devquora
devquora

Posted On: Jun 15, 2021

 

In Data Warehouse, Fact is a quantitative piece of information stored in fact tables and has a foreign key relationship with a number of dimension tables whereas Dimensions are companions to facts, and describe the objects in a fact table.

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