You can use temporary tables to improve the performance of large, complex queries. Temporary tables improve performance because queries to temporary tables on a relational database are faster than repeated queries to the SQL data service for the same data set.

Implementation of temporary tables for performance improvement requires actions by the Informatica administrator and a business intelligence tool developer.

First, the Informatica administrator creates a relational database connection, and configures the Data Integration Service to use the connection.

Then the developer for a business intelligence tool (for example, IBM Cognos or SAP Business Objects) creates a connection between the business intelligence tool and the Informatica SQL data service. The connection uses the Informatica ODBC or JDBC driver.

When these connections are active, the business intelligence tool can create and use temporary tables to process large amounts of intermediate data.