This content has been marked as final. Show 3 replies
What is your exact requirement? is there any data transformation required to transfer the data from upstream to downstream ?
What is your downstream client details? you want to transfer the data one to one or morethan one down stream clients?
We have a ETL login in our local database, and ETL processed data is pulled by our down stream clients, We are seeing that current ETL is not capable enough to execute such a huge load. So we wanted to port our raw data to secondary database and run ETL login on secondary database and to parallelize it accordingly.
I was just thinking, can we use ETL logic inside OGG parameters, so we can load transformed data to secondary database. So no need of running ETL in secondry database. May be i sound little foolish, but just a thought.
You can perform simple transformations. But this really depends on the type of transformations. Because Oracle GoldenGate perform one record a time during replication, for certain ETL transformation, it might not provide the idea performance.
You might also consider Oracle ODI.