Data Transformation Engine Introduction to the Design Studio

Chapter 5 - Database Interface Designer Database Interface Designer Interface
Introduction to the Design Studio
57
The hierarchical structure shown in the Navigator visually provides information
about the contents of each database/query file.
2
Products
query
with no type tree
CUSTOMERS
database/query file
Orders
database
Sales by Year
stored procedures with
generated type tree
Categories
table
with update keys
Current Product List
table with no
update keys
1999Customers
query with
generated type tree
This Navigator example shows a database/query file named CUSTOMERS. The
following information has been defined:
Orders database
1999Customers and Products queries
Type tree generated for the 1999Customers query
No type tree has been generated for the Products query
Type tree generated for the Sales by Year stored procedure
Type tree generated for the Current Product List table
Update keys defined for the Categories table
Variable #01-01-1999#