There are two types of flows: data and control. To model the f lows, a graphical editor is used to place operators onto the editor canvas from a palette and define operator behavior using property pages. There are operators for the common data-warehousing tasks of filtering, de-duping, ordering, joining, unioning, aggregating and transforming data. DB2 column functions are used to transform the data. You can develop DB2 user-defined column functions or the Custom SQL operator to provide custom transformation logic. The data-f low model generates optimized DB2 SQL code, which can then be tested and debugged directly in Design Studio. Once debugged, the data flow is incorporated into a control flow (see Figure 3, page 40). The control f low manages the data f low’s execution sequence along with other kinds of processing. A graphicalflow editor develops control flows. You can employ many kinds of technologies in a data warehouse to accomplish the needed tasks. Moving data around within the database is one, but you may need to run external programs, move FTP files, call stored procedures or run DB2 FIGURE 2 PHYSICAL DATA MODEL J U LY/A UGUS T 20 09 ibms ystemsmag .com/mai nframe 39

For optimal viewing of this digital publication, please enable JavaScript and then refresh the page.
If you would like to try to load the digital publication without using Flash Player detection, please click here.