What are the downsides of having multiple extracts on the same table in golden gate?
I have a scenario where:
PK_NUM COLUMN_ONE COLUMN_TWO
ID1 456 129000
mapping to 2 tables:
PK_NUM COLUMN_VALUE COLUMN_ONE
ID1 randomval 456
PK_NUM COLUMN_VALTWO COLUMN_TWO
ID1 randomval 129000
We are setup currently with 2 extracts on LOCALITY_SETTING_TBL and thus 2 replicats. We basically then say anytime the row changes we replicate the update to the 2 tables, even if only one changed.
This doesn't seem like a scalable solution due to latching, redo reading, or something bad happening. I feel best case is:
one extract on LOCALITY_SETTING_TBL and then in the replicat, just map the before/after's to see what changed and only apply to that table.
What are the downsides to the 2 or more extracts on the same table? Looking for some solid proof or areas to look.