ETL PHASE

ETL PHASE

1. EXTRACTION

   • LOGICAL EXTRACTION
     • FULL
     • INCREMENTAL
   • PHYSICAL EXTRACTION
     • ONLINE
     • OFFLINE
   • IMMEDIATE EXTRACTION
     • CAPTURE THROUGH LOGS
     • CAPTURE IN SOURCE APPLICATIONS
     • CAPTURE THROUGH DATABASE TRIGGERS
   • DEFFERED DATA EXTRACTION
     • DATE AND TIMESTAMP
     • COMPARING FILES

2. TRANSFORMATION

   • TRANSFORMATION TASKS
     • SELECTION
     • SPLIT/JOIN
     • CONVERSION
     • SUMMARIZATION
     • ENRICHMENT
   • METHODS
     • FORMAT REVISION
     • DECODING OF FIELD
     • CALCULATEDD AND DERIVED VALUES
     • DEDUPLICATION
     • SUMMARIZATION
     • MERGING OF INFO
     • KEY RESTRUCTURING
     • DATE TIME CONVERSION

3. LOADING

   • TECHNIQUES
     • INITIAL LOAD
     • FULL REFRESH
       • LOAD
       • APPEND
       • DESTRUCTIVE MERGE
       • CONSTRUCTIVE MERGE
     • INCREMENTAL LOAD
   • TABLES
     • FACT
     • DIMENSION