7 Using Predefined Defaults and Formats
This chapter includes the following sections:
Overview of Predefined Defaults and Formats
To make the task of setting the file writer properties easier, the Oracle GoldenGate Adapter:
-
Sets defaults for some standard properties
-
Includes predefined sets of properties that create a typical format for particular applications receiving the output.
Using these predefined formats changes the standard defaults based on what certain applications typically expect. You can override a format property by manually setting it in the properties file. When processing a property from the format, the system first checks to see if that property is set in the properties file itself. If it is, the property file setting is used, otherwise the format setting is used.
Default Properties
All writers use the following properties. The values shown for each property are the defaults.
writer
.files.data.rootdir=./outwriter
.files.data.rollover.time=10writer
.files.data.rollover.size=100000writer
.files.data.norecords.timeout=10writer
.files.control.use=truewriter
.files.control.ext=.ctrlwriter
.files.control.rootdir=./out
Specifying Consumer Formats
Use the template
property to specify the name of the format file that is to be used.
Syntax
writer
.template=format_name
writer
- Specifies the name of the flat file writer.
format_name
- Specifies the name of an existing file of default property settings for a particular application. Valid sets include:
SIEBEL
- Properties to create one DSV format output file with transaction information for Siebel Remote.ABINITIO
- Properties to create LDV format output for consumption by Ab Initio.NETEZZA
- Properties to create one DSV format output file per table for Netezza.GREENPLUM
- Properties to create one DSV format output file for Greenplum.COMMADELIM
- Properties to create one comma delimited output file per table.
Siebel Remote Format
goldengate.userexit.outputmode=txs goldengate.userexit.buffertxs=true goldengate.userexit.datetime.removecolon=true goldengate.userexit.timestamp=utcwriter
.mode=DSVwriter
.rawchars=falsewriter
.includebefores=truewriter
.includecolnames=truewriter
.omitvalues=falsewriter
.diffsonly=falsewriter
.omitplaceholders=truewriter
.files.onepertable=falsewriter
.files.data.ext=_data.csvwriter
.files.data.tmpext=_data.csv.tempwriter
.files.data.bom.code=efbbbfwriter
.dsv.nullindicator.chars=NULLwriter
.dsv.nullindicator.escaped.chars=writer
.dsv.fielddelim.chars=,writer
.dsv.fielddelim.escaped.chars=writer
.dsv.linedelim.chars=\nwriter
.dsv.linedelim.escaped.chars=writer
.dsv.quotes.chars="writer
.dsv.quotes.escaped.chars=""writer
.dsv.quotealways=truewriter
.groupcols=truewriter
.afterfirst=truewriter
.begintx.metacols="B","S",position,"GGMC",%LAST_UPD_BY,"1", numopswriter
.metacols="R",opcode,%ROW_ID,%LAST_UPD_BY,%LAST_UPD, %MODIFICATION_NUM,%CONFLICT_ID,position,txoppos,table,"","","","","", "",%DB_LAST_UPD,%DB_LAST_UPD_SRC,numcolswriter
.metacols.DB_LAST_UPD.omit=truewriter
.metacols.DB_LAST_UPD_SRC.omit=truewriter
.metacols.opcode.updatepk.chars=Uwriter
.metacols.position.format=decwriter
.endtx.metacols="E"
Ab Initio Format
writer
.mode=LDVwriter
.files.onepertable=falsewriter
.files.data.ext=.datawriter
.files.data.tmpext=.tempwriter
.metacols=position,timestamp,opcode,txind,schema,tablewriter
.metacols.timestamp.fixedlen=26writer
.metacols.schema.fixedjustify=rightwriter
.metacols.schema.fixedpadchar.chars=Ywriter
.metacols.opcode.fixedlen=1writer
.metacols.opcode.insert.chars=Iwriter
.metacols.opcode.update.chars=Uwriter
.metacols.opcode.delete.chars=Dwriter
.metacols.txind.fixedlen=1writer
.metacols.txind.begin.chars=Bwriter
.metacols.txind.middle.chars=Mwriter
.metacols.txind.end.chars=Ewriter
.metacols.txind.whole.chars=Wwriter
.metacols.position.format=decwriter
.ldv.vals.missing.chars=Mwriter
.ldv.vals.present.chars=Pwriter
.ldv.vals.null.chars=Nwriter
.ldv.lengths.record.mode=binarywriter
.ldv.lengths.record.length=4writer
.ldv.lengths.field.mode=binarywriter
.ldv.lengths.field.length=2writer
.statistics.period=onrolloverwriter
.statistics.tosummaryfile=truewriter
.statistics.overall=truewriter
.statistics.summary.fileformat=schema,table,schemaandtable,total, gctimestamp,ctimestampwriter
.statistics.summary.delimiter.chars=|writer
.statistics.summary.eol.chars=\n
Netezza Format
writer
.mode=DSVwriter
.rawchars=falsewriter
.includebefores=falsewriter
.includecolnames=falsewriter
.omitvalues=falsewriter
.diffsonly=falsewriter
.omitplaceholders=falsewriter
.files.onepertable=truewriter
.files.data.ext=_data.dsvwriter
.files.data.tmpext=_data.dsv.tempwriter
.dsv.nullindicator.chars=writer
.dsv.fielddelim.chars=;writer
.dsv.fielddelim.escaped.chars=
Greenplum Format
writer
.mode=DSVwriter
.rawchars=falsewriter
.includebefores=falsewriter
.includecolnames=falsewriter
.omitvalues=falsewriter
.diffsonly=falsewriter
.omitplaceholders=falsewriter
.files.onepertable=truewriter
.files.data.ext=_data.dsvwriter
.files.data.tmpext=_data.dsv.tempwriter
.dsv.nullindicator.chars=writer
.dsv.fielddelim.chars=|writer
.dsv.fielddelim.escaped.chars=writer
.metacols=opcode,timestampwriter
.metacols.opcode.insert.chars=Iwriter
.metacols.opcode.update.chars=Uwriter
.metacols.opcode.delete.chars=D
Comma Delimited Format
writer
.mode=DSVwriter
.rawchars=falsewriter
.includebefores=falsewriter
.includecolnames=falsewriter
.omitvalues=falsewriter
.diffsonly=falsewriter
.omitplaceholders=falsewriter
.files.onepertable=truewriter
.files.data.ext=_data.dsvwriter
.files.data.tmpext=_data.dsv.tempwriter
.dsv.nullindicator.chars=NULLwriter
.dsv.fielddelim.chars=,writer
.dsv.linedelim.chars=\nwriter
.dsv.quotes.chars="writer
.dsv.quotes.escaped.chars=""writer
.metacols=position,txind,opcode,timestamp,schema,tablewriter
.statistics.period=onrolloverwriter
.statistics.overall=true