I have 3 databases; source, intermediate, and destination.
1 - I did synchronous capture at source and apply to the intermediate.
2 - I did also synchronous capture at intermediate to the same apply queue in step 1
3 - I did apply at intermediate and another apply at destination
Now the replication is working fine from source to intermediate and from intermediate to destination but the problem is when I do DML at source it is applied only to the intermediate , I need to apply any change is done in source to both intermediate and destination, any idea?