Design Guide

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

Back Next

Syntax

Flattening is enabled by defining:

the layout of the denormalized (joined) data,

the layout of the flattened IDT, including the maximum number of occurrences for repeating fields,

the columns used to determine how to group denormalized data (Flattening-Keys), and

Flattening-Options.

IDT-Definition

The

Denormalized-View

keyword is used to define the name of the

View-Definition

that provides the layout of the denormalized data. The denormalized data can be read from either a flat-file or UST. If read from a flat-file, you must provide a View-Definition. The view’s name must be the IDT name, suffixed with

"-DENORM"

. If the data is sourced from USTs, a View-Definition is generated automatically from the

User-Source-Tables

section.

A denormalized view is only generated when the UST Definition contains repeating fields defined with the [ ] notation.

The

Flatten-Keys

keyword is used to define the IDT columns used to group (sort) denormalized rows. If more than one column is specified, use a comma-separated list surrounded by quotes ("). The denormalized data are sorted by the

Flatten-Keys

and all rows with the same key value are packed into the same flattened row. Refer to the

Flattening Process

section for details.

The Options keyword in the IDT-Definition is used to specify various flattening options that affect how data is packed into the repeating groups. Refer to the

Flattening Options

section for details.

For example,


IDT-Definition
*==================
NAME= IDT112
DENORMALIZED-VIEW= IDT112-DENORM
FLATTEN-KEYS= "EmpId,EmpName"
OPTIONS= Flat-Remove-Identical

IDT Layout

The IDT layout can be provided as a

File-Definition

(when sourcing from a flat-file) or from the

User-Source-Table

section when sourcing from USTs. The IDT layout must be identical to the Denormalized-View (same column names, types, and order) with the exception that some columns are defined to repeat.

Repeating fields are defined by immediately following the target-field name with [n] where n represents the maximum number of occurrences for a repeating field.

All columns extracted from non-primary (M) tables should use [n] notation.

For example,


Section: User-Source-Tables

create_idt IDT112
sourced_from   odb:99:ssa/ssa@ora817
        Employee.EmpId (PK1)       EmpId,
        Employee.Name              EmpName,
        Address.CompanyId          CompanyId [6],
        Address.Address            Address   [6],
        Phone.Num                  Phone     [6]
join_by
        Employee.EmpId = Address.EmpFK,
        Address.CompanyId = Phone.CompanyId
sync

Rename Saved Search

Table of Contents

Design Guide

Design Guide

Syntax

Syntax

IDT-Definition

IDT Layout