 |
| ELT (Extract Loading And Transformation) |
 |
| ETL(Extarct Transformation And Loading) |
Oracle Data Integrator (ODI) is an E‐LT (Extract, Load and Transform) tool used for high‐speed data movement between disparate systems.
•
ODI is based on metadata .This metadata is stored in a centralized metadata repository
Metadata means data about data. In other words it describes the information system and its contents
It provides faster approach for integration.
So that ODI is simpler and faster integration.
Hi Naresh,
ReplyDeleteI have a question about the diagram displayed in this post. Like you said, ELT architecture improves odi performance when compared to ETL but only when the staging area(temp tables) are created in the target database. If the staging area is separate from the target as shown in the second picture(shown as a separate db), ODI acts similar to a traditional ETL tool. Please correct me if I'm wrong. Thank you!
Yes you are right srilatha. you understood the concept.
ReplyDelete