Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 31
Figure 2-5 Menu options within the InfoSphere Warehouse Administration Console
One of the functions of the runtime element of InfoSphere Warehouse is to
perform the Extract, Transform, Load (ETL) operations on the data contained
within the execution database. These operations are performed by SQW
warehousing applications, which consist of control flows and data flows that have
been created using the SQW development tool Design Studio.
From Design Studio, data flows can be created using building blocks called
“operators.” Each operator performs a specific SQL operation or DB2 command. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.