User`s guide
Simulating and executing a project
30 Sybase IQ ETL 4.1
• All data for all static Lookup components are retrieved and cached.
Any change of data in lookup tables that happens while the project is
simulated is not reflected in the simulation process.
2 Select a component and click Step to execute the component.
Stepping a component means to execute or process a single component
with the data that is currently available at its input ports. The data records
that are being processed during a single step are the records currently
populating the IN-port of the component.
If a component is stepped multiple times and no other components are
stepped in between, the number of records received or forwarded remains
constant. Many components can be stepped from both inside the
component and outside in the project view.
3 View the data flow on the connecting link or within the component.
To view data throughout the transformation process, you can examine the
link between components or the ports of a component. There are also
components with built-in preview capabilities, such as the Data Calculator
and the Data Splitter.
To view data on the link, right-click the connecting link and select Preview
from the pop-up menu.
To view data currently at the port, right-click the port and select Preview
from the pop-up menu.
Some components, such as the Data Calculator or the Data Splitter, allow
you to see the impact of transformation rules from within the component.
To view data from inside the component, double-click the component, or
click Rule in the Property section.
4 Modify and initialize the component.
After you modify a component and decide not to restart a complete
simulation for the current project, you can re-initialize the component to
continue simulating the data flow.
To modify and initialize a component:
a Select the component and modify its properties.
b Save the modifications.
c Right-click the component and select Initialize from the pop-up
menu.