| Loading data from OLTP schema to star schema [message #492780] |
Wed, 02 February 2011 08:19 |
naren.sarkar
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
