Transaction dependency between two different schemas
skurup2Jul 9 2003 — edited Feb 5 2004Could someone tell me how the transaction dependency is handled between two different schemas with two different apply processes.
We are planning to have two schemas with multiple tables and separate apply processes for each schema (separate capture at source site). There are some transactions with dependency between schemas and how this will be handled with 2 apply processes.
According to manual each apply process consists of one reader server, one coordinator process, one or more apply servers. coordinator processes takes care of dependency tracking for this apply processes.
But how will it handle if in our case when there's dependency between two schemas.
Any help will be appreciated.