Oracle Goldengate - What are MACROS in Oracle Goldengate and usage of MACROS
In this session we have discussed regarding Oracle Goldengate Macros OGG Macros
• You can use Oracle GoldenGate macros in parameter files to configure and reuse parameters, commands, and conversion functions. reducing the amount of text you must enter to do common tasks.
• A macro is a built-in automation tool that enables you to call a stored set of processing steps from within the Oracle GoldenGate parameter file.
• A macro can consist of a simple set of frequently used parameter statements to a complex series of parameter substitutions, calculations, or conversions.
• You can call other macros from a macro.
Eg:
macro #do_colmap
params ()
begin
colmap (usedefaults,
Timing = @DATENOW()),
end;
map pdb1.ggtraining1.dept11, target pdb1.ggtraining1.dept22, #do_colmap ();
Video Summary
AI GeneratedThis video explains how to use macros in Oracle GoldenGate to simplify and automate the configuration of parameter files. By defining frequently used commands within a macro, users can avoid repetitive coding, reduce the risk of errors, and make the maintenance of large parameter files significantly easier.

