Data Flow
After a Work Area is installed, you can populate its underlying database schema with data in two basic ways:
-
To load data from an external system, define, install, and run a Load Set (see Loading Data) in the Work Area.
-
To operate on data already stored in Oracle LSH, define a Program in the Work Area and map each of its source Table Descriptors to a Table instance in any Work Area in Oracle LSH (see Operating on Data). Then install and run the Program.
Therefore it is not necessary to load data into the same Work Area where it will be processed. You can load a set of data to one Work Area and read it from a Program in any Work Area afterward. Figure 3-2 represents data flow options graphically.
Parent topic: Work Areas