Frequently Asked Questions
MGA Duplica White Paper - Version 3.01
MGA Duplica F.A.Q.
If you cannot find answers here please go to the MGA Duplica support page.
Can Duplica replicate data from multiple source database?
Yes - User can pick and choose the database (by specifying the database link name) to be the source for each group of tables. Duplica can also replicate data to tables that belong to different users.
Does Duplica support parallel processing?
Yes - Duplica uses the Oracle supplied package, DBMS_JOB, to schedule its background jobs. Jobs are submitted for the control mechanism and for the suites (group of tables) that are scheduled to run. Once submitted, these jobs will be managed by Oracle RDBMS engine, which executes them at the specified interval in parallel sessions that are independent from each other.
Can Duplica replicate only part of the tables?
Yes - Duplica allows the user to specify additional query predicate (in a form of a WHERE condition) to eliminate unwanted rows, thus further qualifying replicated data. Duplica replicates all columns that exist in the target table. Columns that exist in the source table but not in the target table will be ignored
Does Duplica deliver satisfactory performance?
Yes - Duplica performs satisfactorily at all of our clients' sites. Its performance varies vastly from site to site and from application to application due to a number of factors. Some of these are:
The average timings are roughly between 10,000 records per minute to 100,000 records per minute on tables with approximately 3 million rows.
Can Duplica replicate real time changes?
Yes - How long it takes for data to arrive at the target database largely depends on the frequency of replication, which could vary from seconds to days. Acceptable delay can also vary from table to table and needs to be determined by the user based on the intended use of the replicated changes. Replication frequency will then be set accordingly via the GUI tool.