Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate interview questions

BalajidbaDec 13 2019 — edited Jan 8 2020

Hi,

Can someone please check below questions and verify if they are correct.

Kindly add or modify the answers if required.

1.How do you see contents of trail files ?

Trail files are usually found in the GoldenGate dirdat directory. You can also determine the current trail file

directory/name by running the “INFO process_name” command at the ggsci prompt. Open and view the details

of local trail file. Change the file name and location as required.

2. Does DDLs are supported by OGG ?

--Yes

3.List the minimum parameters that can be used to create the OGG extract process?

• USERID

• EXTRACT NAME

• TABLE

• EXTTRAIL

4.What are some of the new features of GoldenGate (OGG) 12c?

Expanded heterogeneous Support.

Multitenant Container Database (CDB) Support.

Oracle Universal Installer (OUI) Support.

Support for Public and Private Clouds.

Integrated Replicat.

5.List a few parameters which you used to improve the OGG replicat process performance?

BATCHSQL

GROUPTRANSOPS

INSERTAPPEND

6.What is the best practice to delete old extract files in OGG?

Regards,

Balaji

This post has been answered by user10126973 on Dec 13 2019
Jump to Answer
Comments
Post Details
Added on Dec 13 2019
6 comments
1,449 views