How to call stored procedure from DAC?

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