ETL Processing
Types of Data Extraction
Logical Extraction
•Full Extraction
•Incremental Extraction
Physical Extraction
•Online Extraction
•Offline Extraction
•Legacy vs. OLTP
Data Transformation basic tasks
•Selection
•Splitting/Joining
•Conversion
•Summarization
•Enrichment
•Data Mining is primarily used today by companies with a strong consumer focus- retail, financial, communication, and marketing organizations, to “drill down” into their transactional data and determine pricing, customer preferences and product positioning, impact on sales, customer satisfaction and corporate profits.
