Oracle^® Business Intelligence Data Warehouse Administration Console Guide > Common Tasks Performed in the DAC >

Replacing an Informatica Workflow with a Custom SQL File

You can improve the performance of loads by replacing Informatica workflows with custom SQL files.

To replace an Informatica workflow with a custom SQL file

1. Create a SQL file to be used to load the table, and unit test it.
2. Create an XML or SQL file with one or more SQL statements in the format that the DAC can understand.

   For more information about creating an XML or SQL file, see Using SQL Files as an Execution Type in the DAC.

   You can create one file for a full load and one for an incremental load, or you can use the same file for both full and incremental loads.

3. Save the file in the OracleBI\DAC\CustomSQLs directory.
4. In the Tasks tab of the DAC Design view, query for the task for which you want to replace the Informatica workflow.
5. Replace the workflow name in the Command for Incremental Load or Command for Full Load fields with the XML or SQL file.
6. Change the Execution Type to SQL.