Chapter 9 Data Transformations Basics

Create high-level transformation diagram

You create an high level transformation diagram (using the Information Liquidity Diagram) to define the high-level view of data transformation, which includes:

• Source data stores — which can be a database, an XML document, a business process, and a flat file.
• A transformation process — which lets you detail each transformation task in the Data Transformation Diagram and also detail the sequence of execution of a series of transformation tasks in the Transformation Control Flow Diagram.
• Target data stores — which can be a database, an XML document, and a flat file

If you did not use the reverse engineer feature, you have to associate a model to each one of the data stores in order to establish a connection with the associated model. This connection is used by data inputs in the data transformation diagram.

The flat file is usually a .csv or .xls file containing columns. You create columns using the Columns tab in the flat file property sheet.

For more information about information liquidity diagrams, see the "Building Information Liquidity Diagrams" chapter

Copyright (C) 2007. Sybase Inc. All rights reserved.