When would you use the PASSTHRU parameter?

When would you use the PASSTHRU parameter? A. When using a data pump to distribute all of the trail data “as is” to a remote system. B. When Extract is processing database transaction logs where you have a remote database connection. C. For a SPECIALRUN one-time processing task that is doing an initial load. D. […]

Read More

To prevent looping of DDL statement like CREATE TABLE

You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (….), the best solution is______. A. Include the tranlogoptions (exclude user) parameter in each Extract parameter file B. Use the add FILTERTABLE command at the GGSCI prompt C. Use DDL exclude OPTYPE (create table. . . ) in […]

Read More

what must be considered configuring the middle-tier server for Capture?

When GoldenGate is configured for Archived Only Mode (ALO), what must be considered configuring the middle-tier server for Capture? A. The middle-tier capture server has the same endian order and bit width B. The middle-tier server must have a database installed on it C. GoldenGate only supports Windows or Linux on the middle-tier server D. […]

Read More