What's the difference between Oracle GoldenGate
and Oracle ODI
? Which one is the ETL tool?
Why two tools? (Their product descriptions are fuzzy enough that it's hard for the layman to tell the difference).
if the two tools are appropriate, isn't that a big learning curve to learn two separate (albeit complementary) tools?
It seems to me GoldenGate is a "data replication tool", layman's view: it moves data from point A to point B.
- but it also says it does "transformations", so doesn't that translate to an E-T-L tool?
The ODI product home page doesn't say anything about transformation.
This is a good article
but still my understanding on the differences is fuzzy ...
===== background =====
I'm a data warehouse consumer and designer of a relational d.b. data warehouse. Never got into the multi-dimensional or star schema stuff.
So I'm not building the infrastructure for the data warehouse, but I might write the ETL specs. In other words, I know the data and know my reporting requirements, with a strong SQL knowledge and understanding of the business.
But I need to know some of the tools to best understand the environment and work with the builders of the data warehouse.