About mappings
When the Integration service processes an Actuate SQL query, one of the following occurs:
*
*
*
Figure 8-3 shows how the Integration service processes an Actuate SQL query when parts of the query are executed by the database, while other parts of the query are executed by the Integration service.
Figure 8-3  
You optimize performance by having the database execute as much of the query as possible. Mappings translate Actuate SQL into the database’s native SQL and ensure that an Actuate SQL query returns the same results for every database type. For example, a DB2 database and an Oracle database have identical schemas. You create an Actuate SQL query using maps that represent tables from one of these databases. The query returns the same results whether the maps represent DB2 tables or Oracle tables.
Specifically, a mapping defines how to map Actuate SQL data types to a database’s native SQL data types. A mapping also defines how to map the following Actuate SQL constructs to the corresponding native SQL constructs:
*
*
*
*

Additional Links:

Copyright Actuate Corporation 2012