We are planning to use shareplex for data replication and transformation based on CDC from various source database tables to target database tables. The source and target systems are Oracle database in this case. The target database serves as a reporting database for operational reporting. We are also looking to leverage shareplex to perform minor data transformations. As I understand it can be achieved by writing PL/SQL procedures and these transformations will be performed on the fly along with data replication. Can you confirm that there wont be any performance bottleneck when using PL.SQL procedures for data transformation?
There are multiple source systems spread across different databases across different servers. Say there are 3 source systems, and few columns from first,second and third database tables need to be replicated to a single target database table in real time.Is it possible ? Do we have any limitation on the number of allowed parallel Shareplex connections to a single target table?