Structure/design | Kirix Strata Blog

Kirix Strata Blog

Archive for the ‘structure/design' Category

Setting Table Structure Prior to Import

Wednesday, February 25th, 2009

Script Snippet Image

Strata can work directly with fixed-length or delimited text files. Let's say we need to change the structure of a text-delimited file — say, making a field with smaller to truncate unnecessary values and reduce our files size. We can do this using two methods, either by manually changing our values or by changing the values programmatically prior to import. (As an example, we may have wanted to reduce our web log field width size in this example).