ODI 12c supports both the methods.
ETL: (Extract , Transform and load):
- Transform in separate ETL server
- Dedicated server
- Reduced performance
- High Costs
ELT(Extract, load and transform):
- Transform in existing RDBMS
- Leverage resources
- Increased performances
- Easier to manage abd lower costs
No comments:
Post a Comment