Monday, 31 October 2022

Types of load in ETL?

Full load (bulk load)

The data loading process when we do it the very first time. It can be referred to as bulk load or fresh load.


Incremental load

The modified data alone will be updated in target followed by a full load. The changes will be captured by comparing created or modified date against the last run date of the job.


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to perform regression testing in ETL?

Regression testing in ETL (Extract, Transform, Load) ensures that changes or updates to the ETL process do not negatively impact existing fu...

  • Explain incremental data loading?
    Incremental data loading is a technique used in ETL (Extract, Transform, Load) processes to load only the new or changed data since the last...
  • How to perform regression testing in ETL?
    Regression testing in ETL (Extract, Transform, Load) ensures that changes or updates to the ETL process do not negatively impact existing fu...
  • Dimensional Modeling?
      Dimensional modeling is a design technique used in data warehousing to structure data for efficient querying and reporting. It organizes d...