P L Robert Danielsson-Oldberg
03-24-2004, 08:15 AM
Hello.
OB_crosspost_excuse:
Excuse the crosspost, followups are directed to comp.databases.oracle.server
alone. It seems to me the subject is both a server and a tools (misc?) matter.
I've been challenged by my employee to set up a datawarehouse with
daily loading of update/inserted data. To build the warehouse I've
utilized Oracle Warehouse builder and to catch changes to the production
tables to bring to the warehouse I've set up Change Data Capture on
the tables I need to watch.
Just the small task of integrating the two to a working warehouse left. :)
It seems there's no easy way to access the subscriber views with static
names, so I have to drop and create new synonyms for them with PL/SQL
every night. Anyone who've thought of something I haven't here?
Has anyone any experience with filtering out data from change tables
with OWB? Getting only the 'I' and 'UN' fields from them will get
me the data I need, but joining several change tables and using
either update/insert or insert/update as the loading models is something
I've newer tried.
Anyone with experince who can give me a hint? I'll continue labbing with
it in the meantime :)
The only articles involving CDC I've seen have been a year or more old.
Jusung Yang, Yong Huang and (of course :) Thomas Kyte are the ones I've seen
having answers for CDC newbies here, are you still around?
Sincerely,
Robert Oldberg.
Please use the below adress, without the spam clause, to reply to me:
robert.oldberg@*NO_SPAM*novamedia-se.com
OCP DBA, OWB uncertified greenhorne, CDC uncertain user
--
Robert |GCS/S/MU d-- h--- s+: g+- au+ a- w++ v-(++) C++++ U++++ S+ P- L 3
Danielsson|R+++ N+++ K- W--- M-- V- -po+ Y+ t+ !5 j- r+ tv- b+ D- B? e+++ u+++
Oldberg |G''' h--- !f r+++ n--- y? E--- H- http://www.dtek.chalmers.se/~d9rd
OB_crosspost_excuse:
Excuse the crosspost, followups are directed to comp.databases.oracle.server
alone. It seems to me the subject is both a server and a tools (misc?) matter.
I've been challenged by my employee to set up a datawarehouse with
daily loading of update/inserted data. To build the warehouse I've
utilized Oracle Warehouse builder and to catch changes to the production
tables to bring to the warehouse I've set up Change Data Capture on
the tables I need to watch.
Just the small task of integrating the two to a working warehouse left. :)
It seems there's no easy way to access the subscriber views with static
names, so I have to drop and create new synonyms for them with PL/SQL
every night. Anyone who've thought of something I haven't here?
Has anyone any experience with filtering out data from change tables
with OWB? Getting only the 'I' and 'UN' fields from them will get
me the data I need, but joining several change tables and using
either update/insert or insert/update as the loading models is something
I've newer tried.
Anyone with experince who can give me a hint? I'll continue labbing with
it in the meantime :)
The only articles involving CDC I've seen have been a year or more old.
Jusung Yang, Yong Huang and (of course :) Thomas Kyte are the ones I've seen
having answers for CDC newbies here, are you still around?
Sincerely,
Robert Oldberg.
Please use the below adress, without the spam clause, to reply to me:
robert.oldberg@*NO_SPAM*novamedia-se.com
OCP DBA, OWB uncertified greenhorne, CDC uncertain user
--
Robert |GCS/S/MU d-- h--- s+: g+- au+ a- w++ v-(++) C++++ U++++ S+ P- L 3
Danielsson|R+++ N+++ K- W--- M-- V- -po+ Y+ t+ !5 j- r+ tv- b+ D- B? e+++ u+++
Oldberg |G''' h--- !f r+++ n--- y? E--- H- http://www.dtek.chalmers.se/~d9rd