You have 3 options.
Option 1:
Create an SQL file that runs the stored proc. For instance, if
your stored proc is called "aggregate_proc" you would create a
file called aggregate_proc.sql that has the syntax to run the
stored proc. Put the file in the CustomSQLs directory that hangs
off the DAC main directory. Then, in the DAC, create a new task
(Execution Type = SQL File). The command for Incremental Load
would be aggregate_proc.sql.
Option 2:
Create an Informatica mapping (and corresponding workflow) that
runs the stored proc. Then create a DAC task (Execution type Informatica) that runs the workflow.
Option 3 :
Directly mention Schema.procedure name in the DAC task
