1.

Explain the three-layer architecture of an ETL cycle.

Answer»

Typically, ETL tool-based data warehouses use STAGING areas, data integration layers, and access layers to ACCOMPLISH their work. In general, the architecture has THREE layers as shown below: 

  • Staging Layer: In a staging layer, or source layer, data is stored that is extracted from MULTIPLE data sources.
  • Data Integration Layer: The integration layer plays the role of transforming data from the staging layer to the database layer.
  • Access Layer: Also called a dimension layer, it allows USERS to retrieve data for analytical reporting and information retrieval.


Discussion

No Comment Found

Related InterviewSolutions