Click here to Skip to main content
15,891,423 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: (untagged)
Some of my colleagues are using Ab Initio and they talk about creating "load ready" files. I have been trying to find out about the format of these with the idea that I may be able to read them -- no, my colleagues have no clue.

Can any of you point me to some detailed documentation of Ab Initio's load ready file format?

What I have tried:

On the Ab Initio site I saw a reference to "Indexed Compressed Flat File" which uses "standard (non-proprietary) compression", but I have been unable to locate a specification for these files.
Posted
Updated 7-Jan-21 12:28pm

1 solution

Wow. What a crappy site.

"Load Ready" just means the data in the file is ready to be imported into a database and you shouldn't have any errors or problems. The file and the data in it are essentially "pre-screened" and verified to be accurate and follow all the rules of the database before the import is started.

Looking at some other questions on Al Initio, it may be that a .DAT file is just a text file with fixed column widths, but, of course, that doesn't take into account the compression, which I couldn't find any information on.

Oracle has a configuration in their GoldenGate product that appears to describe the Ab Initio file format in GoldenGate terms, for what it's worth:
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 
 
Share this answer
 
Comments
PIEBALDconsult 7-Jan-21 19:45pm    
Hmm, thanks.
writer.statistics.summary.delimiter.chars=|
writer.statistics.summary.eol.chars=\n
CSV? Ew.

I suppose that makes some sense. One of the worst things I know about Ab Initio is it can't even read a proper CSV file.
My boss says the "load ready" files are encrypted, and that may be only to ensure that no one messes with them.
Dave Kreskowiak 8-Jan-21 0:33am    
I hate vendors. They do stupid things.
PIEBALDconsult 8-Jan-21 9:43am    
Then they say "we're the fastest, we're the best" and middle-managers eat it up.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900