Tuesday, January 20, 2015

ETL Job or Components

ETL Components:


ETL Job or Components
ETL Job or Components
  1. Data Extraction
  2. Data Transformation
  3. Data Loading
  4. Data Refresh Method
  5. Data Sourcing Method
  6. Data Landing / Staging Design
  7. Job Scheduling
  8. Job Sequencing
  9. Historical Data Migration
  10. Changed Data Captrue
  11. Audit & Verification
  12. Admin
  13. Validation & Cleansing
  14. Aggregate
  15. Logging & Monitoring
  16. Surrogate Key Generation & Mgmt
  17. History / SCD Mgmt
  18. Exception Handing
  19. Data Conformation & De duping
  20. Restart / Reload



1 comment :

  1. ETL stands for Extract-Transform-Load and it is a process of how data is loaded from the source system to the data warehouse. Data is extracted from an OLTP database ... Layman Learning- ETL Testing Training
    MOB: +91-741-626-7887 - Website : www.laymanlearning.com || hr@laymanlearning.com ||

    ReplyDelete