Tuesday, March 04, 2008

Different types of ETL operations

Filters
- Selection (σ)
- Not null (NN)
- Primary key
violation (PK)
- Foreign key
violation (FK)
- Unique value (UN)
- Domain mismatch (DM)
Unary operations
- Push
- Aggregation (γ)
- Projection (π)
- Function application (f)
- Surrogate key assignment (SK)
- Tuple normalization (N)
- Tuple denormalization (DN)
Binary operations
- Union (U)
- Join (>< )
- Diff (Δ)
- Update Detection (ΔUPD)
File operations
- EBCDIC to ASCII conversion
(EB2AS)
- Sort file (Sort)
Transfer operations
- Ftp (FTP)
- Compress/Decompress (Z/dZ)
- Encrypt/Decrypt (Cr/dCr)

No comments: