Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure
Database Interface Designer Reference Guide
73
As shown in these examples, the type trees generated from tables, views, queries,
and stored procedures are very similar, while the type tree generated for message
queues differs slightly.
In these example type trees:
♦ The type tree named ActvProj.mtt was created for a query that referenced a
Microsoft Access table.
♦ The type tree named Stores.mtt was created for a table in a Microsoft SQL
Server database.
♦ Two type trees were created for stored procedures in an Oracle database.
! The PymtInfo.mtt type tree was generated for a query called
GetPaymentInfo that calls an Oracle stored procedure to be used as a
map data source.
! The ApplyPmt.mtt type tree was generated for the
SCOTT.APPLY_PAYMENT stored procedure to be used as a map output.
♦ The type tree named Paulmsg.mtt was generated from a message queue on
the PAUL_MSG_QUEUE.
Table and Query Type Tree Structure
Type trees generated for a query and a table closely resemble one another.
Generated from
a table
Generated
from a query