Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees

Database Interface Designer Reference Guide

Field Description

File name This field displays a system-generated file name based

upon the database selection in the Navigator. The

default value is the database name with a type tree

extension (.mtt) and a default path.

To change any of this information, click

(browse).

Overwrite file This check box determines whether you want to replace

the existing type tree file (.mtt) upon saving it. The

default value is disabled.

Override type This check box determines whether to replace existing

types with matching, newly generated types and to add

any non-matching new types to the type tree file (.mtt).

This is useful when you want to add types for additional

tables into an existing type tree. The default value is

enabled.

Row group format This list displays options to determine the row format in

the generated type tree. The default value is Delimited.

Delimited Select this option to create rows delimited with a pipe

character (|) or some other user-defined selection. This

is the preferred option if you are using large column

widths where the values may be smaller than the width

of the columns. The pipe character is the default

selection.

Fixed Select this option to create rows of fixed size in the

generated type tree. There are certain situations in

which you would want to select Fixed:

♦ The query result contains a large number of rows

where each row consists of small, fixed-length fields.

In this situation, delimiters are unnecessary and they

also consume memory.

♦ You need to append fields in the output. This may be

true if multiple fields have some meaning when

concatenated together.