Friday, September 24, 2021

ODI - ETL vs ELT

 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

Featured Post

OIC Common Service to Submit CCS Batch Jobs and Monitor Job Status | Extract file from Oracle CCS to Object Storage

Objective Create a reusable common service in Oracle Integration Cloud (OIC) to submit batch jobs to CCS, monitor their execution status, an...