Search

Design Guide

Design Guide

10.5 HotFix 3
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

Identity Table Definition

Identity Table Definition

This begins with the

IDT-DEFINITION

keyword and defines an IIR Identity Table. The fields are as follows:

Field	Descriptions
NAME=	A character string that specifies the name of the IDT. This is a mandatory parameter
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 Flattening IDTs section in this guide for details. This is an optional parameter.
FLATTEN-KEYS=	A character string that defines the IDT columns used to group denormalized rows during the Flattening process. A maximum of 36 columns may be specified. Refer to Flattening IDTs section in this guide 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.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.