Explain the three-level hierarchy of a typical ETL cycle.

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

The typical three-level hierarchy of an ETL cycle is composed of the following:

  • Staging Layer − This layer is utilized to store the information extricated from various source information frameworks.
  • Data Integration Layer − This layer changes the information from the organizing layer and moves the information to a database, where the information is masterminded into various leveled gatherings, frequently called measurements, and into actualities and total realities. The blend of realities and measurements tables in a DW framework is known as an outline.
  • Access Layer − This layer is utilized by end-clients to recover the information for explanatory detailing.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    ETL Testing Interview Questions

    What are the testing procedures included in ETL?

    The various testing procedures included in ETL include the following:..

    ETL Testing Interview Questions

    What do you understand by the terms initial load and full load?

    In ETL, the initial load is the procedure for populating all information warehousing tables for the absolute first time...

    ETL Testing Interview Questions

    Describe data profiling with respect to ETL system.

    Data profiling is an efficient examination of the quality, degree, and setting of an information..