Home » Other » General » Loading data from OLTP schema to star schema (Oracle 10g)
Loading data from OLTP schema to star schema [message #492780] Wed, 02 February 2011 08:19
Messages: 16
Registered: April 2008
Junior Member
I have a requirement where I need to load data from OLTP schema(normalized schema) to star schema. Informatica ETL upload data from source system to OLTP schema. After each upload the change log need to be uploaded in the star schema. We are thinking following approach to upload these change log in the star schema.
1) Capture the change log from the table trigger.
2) Identify new records in a table and fire DBMS job to upload these data.

However both the strategies have some shortcoming. Can anybody share what would be the best approach to synchronize these two schemas.
Previous Topic: how does stored procedure wok between timesten and oracle database
Next Topic: Advantages of Type Objects over Packages
Goto Forum:

Current Time: Wed Aug 17 23:16:20 CDT 2022