Attribute

FlattenArrayBase (fab)

Purpose

Specifies the starting ordinal value appended to column names for flattened arrays. When flattening arrays, column names are appended with an underscore and the ordinal value (<array_name>_<ordinal_location>).

Valid Values

0 | 1

Behavior

If set to 0, the first column name in the array will be appended with an _0. For example, the first three columns generated in the vehicles array would be the following in the Mixed relational view: VEHICLES_0, VEHICLES_1, VEHICLES_2.

If set to 1, the first column name in the array will be appended with an _1. For example, the first three columns generated in the vehicles array would be the following in the Mixed relational view: VEHICLES_1, VEHICLES_2, VEHICLES_3.

Default Value

1