This chapter includes the following sections:
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.
All writers use the following properties. The values shown for each property are the defaults.
writer.files.data.rootdir=./out writer.files.data.rollover.time=10 writer.files.data.rollover.size=100000 writer.files.data.norecords.timeout=10 writer.files.control.use=true writer.files.control.ext=.ctrl writer.files.control.rootdir=./out
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.goldengate.userexit.outputmode=txs goldengate.userexit.buffertxs=true goldengate.userexit.datetime.removecolon=true goldengate.userexit.timestamp=utc writer.mode=DSV writer.rawchars=false writer.includebefores=true writer.includecolnames=true writer.omitvalues=false writer.diffsonly=false writer.omitplaceholders=true writer.files.onepertable=false writer.files.data.ext=_data.csv writer.files.data.tmpext=_data.csv.temp writer.files.data.bom.code=efbbbf writer.dsv.nullindicator.chars=NULL writer.dsv.nullindicator.escaped.chars= writer.dsv.fielddelim.chars=, writer.dsv.fielddelim.escaped.chars= writer.dsv.linedelim.chars=\n writer.dsv.linedelim.escaped.chars= writer.dsv.quotes.chars=" writer.dsv.quotes.escaped.chars="" writer.dsv.quotealways=true writer.groupcols=true writer.afterfirst=true writer.begintx.metacols="B","S",position,"GGMC",%LAST_UPD_BY,"1", numops writer.metacols="R",opcode,%ROW_ID,%LAST_UPD_BY,%LAST_UPD, %MODIFICATION_NUM,%CONFLICT_ID,position,txoppos,table,"","","","","", "",%DB_LAST_UPD,%DB_LAST_UPD_SRC,numcols writer.metacols.DB_LAST_UPD.omit=true writer.metacols.DB_LAST_UPD_SRC.omit=true writer.metacols.opcode.updatepk.chars=U writer.metacols.position.format=dec writer.endtx.metacols="E"
writer.mode=LDV writer.files.onepertable=false writer.files.data.ext=.data writer.files.data.tmpext=.temp writer.metacols=position,timestamp,opcode,txind,schema,table writer.metacols.timestamp.fixedlen=26 writer.metacols.schema.fixedjustify=right writer.metacols.schema.fixedpadchar.chars=Y writer.metacols.opcode.fixedlen=1 writer.metacols.opcode.insert.chars=I writer.metacols.opcode.update.chars=U writer.metacols.opcode.delete.chars=D writer.metacols.txind.fixedlen=1 writer.metacols.txind.begin.chars=B writer.metacols.txind.middle.chars=M writer.metacols.txind.end.chars=E writer.metacols.txind.whole.chars=W writer.metacols.position.format=dec writer.ldv.vals.missing.chars=M writer.ldv.vals.present.chars=P writer.ldv.vals.null.chars=N writer.ldv.lengths.record.mode=binary writer.ldv.lengths.record.length=4 writer.ldv.lengths.field.mode=binary writer.ldv.lengths.field.length=2 writer.statistics.period=onrollover writer.statistics.tosummaryfile=true writer.statistics.overall=true writer.statistics.summary.fileformat=schema,table,schemaandtable,total, gctimestamp,ctimestamp writer.statistics.summary.delimiter.chars=| writer.statistics.summary.eol.chars=\n
writer.mode=DSV writer.rawchars=false writer.includebefores=false writer.includecolnames=false writer.omitvalues=false writer.diffsonly=false writer.omitplaceholders=false writer.files.onepertable=true writer.files.data.ext=_data.dsv writer.files.data.tmpext=_data.dsv.temp writer.dsv.nullindicator.chars= writer.dsv.fielddelim.chars=; writer.dsv.fielddelim.escaped.chars=
writer.mode=DSV writer.rawchars=false writer.includebefores=false writer.includecolnames=false writer.omitvalues=false writer.diffsonly=false writer.omitplaceholders=false writer.files.onepertable=true writer.files.data.ext=_data.dsv writer.files.data.tmpext=_data.dsv.temp writer.dsv.nullindicator.chars= writer.dsv.fielddelim.chars=| writer.dsv.fielddelim.escaped.chars= writer.metacols=opcode,timestamp writer.metacols.opcode.insert.chars=I writer.metacols.opcode.update.chars=U writer.metacols.opcode.delete.chars=D
writer.mode=DSV writer.rawchars=false writer.includebefores=false writer.includecolnames=false writer.omitvalues=false writer.diffsonly=false writer.omitplaceholders=false writer.files.onepertable=true writer.files.data.ext=_data.dsv writer.files.data.tmpext=_data.dsv.temp writer.dsv.nullindicator.chars=NULL writer.dsv.fielddelim.chars=, writer.dsv.linedelim.chars=\n writer.dsv.quotes.chars=" writer.dsv.quotes.escaped.chars="" writer.metacols=position,txind,opcode,timestamp,schema,table writer.statistics.period=onrollover writer.statistics.overall=true