User`s guide

CHAPTER 6 Components
User’s Guide 83
• Database
• Schema
• Database options
Impact on simulation sequence
Read Block Size value impacts the number of records loaded in a single
simulation step.
Projects in DemoRepository and Help Flash movie:
• Demo Transfer US Products
• Demo Transfer German Sales
DB Data Provider Index Load
This component allows you to perform incremental data loads. Data records
already extracted by previous executions of the project will be skipped. The
incremental load is controlled by an attribute containing ascending values, the
Ascending Index.
During simulation of a project, you can manipulate the value of the Ascending
Index with the Load Index Value property.
The value of the Load Index is not updated within the Sybase IQ ETL
Development Repository when the project is executed during simulation.
Note To perform an incremental load using the stored value of the Ascending
Index, projects using this component must be executed within a job or
schedule.
Use this component if you need to track source changes on a regular basis. The
loading time can be significantly reduced only if the delta of the day has to be
transferred, instead of loading very large tables or views on a daily basis.
❖ To enter required properties
1 Enter the Connection Parameters as described in “Entering database
connection parameters” on page 71.
2 Select the Ascending Index attribute from the list of database objects.