You can configure the Integration Service to perform a test load. With a test load, the Integration Service reads and transforms data without writing to targets. The Integration Service reads the number you configure for the test load. The Integration Service generates all session files and performs all pre- and post-session functions, as if running the full session. To configure a session to perform a test load, enable test load and enter the number of rows to test.
The Integration Service writes data to relational targets, but rolls back the data when the session completes. For all other target types, such as flat file and SAP BW, the Integration Service does not write data to the targets.
Use the following rules and guidelines when performing a test load:
You cannot perform a test load on sessions using XML sources.
You can perform a test load for relational targets when you configure a session for normal mode.
If you configure the session for bulk mode, the session fails.
Enable a test load on the session Properties tab.