Preface
Using the Designer
Working with Sources
Working with Flat Files
Working with Targets
Mappings
Mapplets
Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger
Viewing Data Lineage
Comparing Objects
Managing Business Components
- Managing Business Components Overview
  - Business Component Locking
  - Creating Links to Business Component Documentation
- Managing Business Components and Directories
Creating Cubes and Dimensions
Using the Mapping Wizards
Appendix A: Datatype Reference
Appendix B: Configure the Web Browser
- Configure the Web Browser

Designer Guide

10.5
- 10.5.6
- 10.4.1
- 10.4.0

Back Next

OCCURS

COBOL files often contain multiple instances of the same type of data within the same record. For example, a COBOL file may include data about four different financial quarters, each stored in the same record. When the Designer analyzes the file, it creates a different column for each OCCURS statement in the COBOL file. These OCCURS statements define repeated information in the same record. Use the Normalizer transformation to normalize this information.

For each OCCURS statement, the Designer creates the following items:

One target table when you drag the COBOL source definition into the Target Designer.

A primary-foreign key relationship

A generated column ID (GCID)

Components in a COBOL Source File

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal