This optional section begins with the

IDT-DEFINITION

keyword and defines a DCE Identity Table. If you don’t need to specify any other IDT parameters except its name, then you can omit this section and specify the IDT name using the

FILE=

keyword under the

Project-Definition

section (see the

Project Definition

section above).

The fields are as follows:

Field	Description
NAME=	A character string that specifies the name of the IDT. This is a mandatory parameter (unless the whole IDT-DEFINITION section is omitted).
DENORMALIZED-VIEW=	A character string that specifies the name of the View-Definition that defines the layout of the denormalized data for Flattening. Refer to the Flattening IDTs section for details. This is an optional parameter.
FLATTEN-KEYS=	A character string that defines the columns used to group denormalized rows during the Flattening process. Refer to the Flattening IDTs section for details. This is an optional parameter.
OPTIONS=	This is used to specify various options to control the data stored in the IDT: FLAT-KEEP-BLANKS - a flattening option that maintains positionality of columns in the flattened record. Refer to the Flattening IDTs section for details. FLAT-REMOVE-IDENTICAL - a flattening option that removes identical values from a flattened row. Refer to the Flattening IDTs section for details.