You want to map exception to an exceptions table using the MAPEXCEPTION option of the MAP parameter. When should you proceed? A. when the names of both the source and target tables in the MAP statement are wildcarded B. when…
Which other character, besides the COMMENT parameter, can you use to enter remarks in a parameter file? A. \ B. // C. – – D. *
You want to reduce an Integrated Extract’s startup time by using an existing data dictionary. How should you accomplish this? A. Set the shared memory realm of an Integrated Extract with other Integrated Extracts. B. Use the SHARE option of…
You need to manually patch Oracle GoldenGate source and targets. How should you proceed? A. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying…
You have a source table with a PRODUCT_ID column and a target table with PRODUCT_DESCRIPTION column. On the target database, there is a lookup table containing product codes and corresponding descriptions. What should you use to look up the PRODUCT_DESCRIPTION…
What sequence of steps should you follow to add a data pump that reads from a local trail? A. In GGSCI, on the source system, issue the command: ADDEXTRACT group name, TRAILSOURCE trail name. B. In GGSCI, on the source…
Which Replicat MAP parameter and syntax should be used to detect an update conflict on the EURO.SEAT_RESV table and resolve the conflict by determining which record has the oldest LAST_UDATE value? A. MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING…
With BATCHSQL enabled, what causes a Replicat to use normal mode operation? A. statements with rows between 8k and 24k in length B. when BATCHSQL and GROUPTRANSOPS coexist C. statements which cause errors D. when server memory < 8GB
An integrated Replicat is running with PARALLELISM set to four, yet you discover that for a series of large operations, only one apply server is processing the operations. What is the reason for this issue? A. Operations are grouped into…
Which option is not included as part of a Veridata installation? A. Veridata BackPlane Server B. Veridata Agent C. Veridata Web Server D. Veridata Repository