This discussion is archived
1 Reply Latest reply: Oct 15, 2012 7:45 PM by Nasar RSS

ETL Publish/Subscriber Question

968055 Newbie
Currently Being Moderated
I have a question about the CDC publish/subscribe usage with ETL on Oracle 10g. Is the ETL logic code part of the subscriber part? In other words, when the publisher is notified of a record change and sends the record to the staging area then calls the subscriber. Is the subscriber that runs the ETL logic that processes the record before it is sent to the DW/Dim tables? Something like this flow:
Source Database ---> Change table/Publish ---> Subscribe view/ETL ---> Target Database

Thanks in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points