Re: Change Data Capture for ETL.
- From: Bagavath <bagavath@xxxxxxxxx>
- To: thump@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 27 Apr 2007 23:46:10 -0400
David, Would you be willing to share some pain areas ? We have set up cdc ( async dist hot log ) for our warehouse but not into production yet. Except for a few glitches it seems to work so far, but we havent really put it to work with realtime data. Thanks Bagavath On 4/27/07, David <thump@xxxxxxxxxxxxxxxx> wrote:
It's bleeding edge in 10202. We have it working, but it's been painful. As Tim mentioned, I wouldn't even attempt such under 9i. Tons of bugs and issues... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Larry G. Elkins Sent: Friday, April 27, 2007 7:42 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Change Data Capture for ETL. Do you care to clarify? Your comments about CDC prior to 10.2, is it mainly about performance, or is it about bugs, difficult to administer, or a combination of all? We've got some DW folks I work with a lot and they are wanting to use CDC, 126.96.36.199 for both source and target, which means it would still be using change tables somewhat similar to the MLOG$ tables along with triggers on the source table(s). They want this happening in "real time" against an already *very* active OLTP database. We have put them off (they are looking at sometime in the next six months to implement) until we can actually test the impact, and suggested testing streams also with the idea it would be lighter weight. Plus give us time to find out what business need they are really trying to solve with this "real time" requirement for data in the DW from the OLTP. In other words is this *really* needed to meet the business need they are trying to take care of. Or is there someway besides real time replication to meet the need? Don't know the answer. My understanding is that with CDC in 10g it is much lighter weight, using streams to hit the log files and AQ, and able to do asynchronously. It's been only the last few weeks that I've started to read up on CDC, able to spend an hour here or there trying to learn more about it. So any more information you have would be appreciated. Larry G. Elkins elkinsl@xxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Gorman Sent: Friday, April 27, 2007 5:34 PM To: Srini_Karla@xxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Change Data Capture for ETL. Srini, I have, and I sincerely doubt that you'll have any fun with it below v10.2. But you can certainly have fun trying... ;-) Tim Gorman -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l