We were planning to implement the ETL using PLSQL and not Informatica but we were interested in using DAC for scheduling and managing the ETL(PLSQL) runs in the way it currently does for Informatica. Can you please let us know if this is feasible.
Primarily we want to use the DAC parameter management, Task management, Scheduling management and parallel execution of tasks.
You can run a stored procedure from either Informatica (pre/post SQL) or from the DAC via a TASK action. Check the DAC configuration guide under the section "7 About Index, Table and Task Actions" for details on this. If this was helpful please mark as helpful or correct.
Yes.. we are aware that we can run the PLSQL procedures via DAC Tasks, but, our requirement is that DAC functions totaly independent of Informatica. To say in simple words we are rewriting our ETL code in PLSQL, and want to use DAC for scheduling and executions of our ETL code (PLSQL procedures). The prime reason for this is DAC handles ETL Run History and the last extract time and also provides parallel execution of ETL Tasks.
So are you not using the BI Apps?? Is this for a custom DW? I cannot possibly imagine the advantage of rewriting OBIA ETL code in pl/sql..it seems to defeat the purpose of pre-packaged apps. To answer you questions, I do not believe you can just remove the ETL tool completely from the equation. The DAC is tightly integrated with Informatica and tasks translate to PMCMD commands. As you mentioned, you can add task actions to run stored procedures as pre/post tasks actions or table actions but seems you just want to remove the ETL tool completely from the picture. The DAC used Informatica Folder (logical to physical mappings), Task phases, folder priorities, and source/target dependencies to calculate the execution order for each execution plan. If you use only pl/sql and removing Informatica, how would the DAC know how to order the tasks for parallell execution? Will you manually define the source, targets, lookups, phases?? This does not seem feasible. Bottom line, you can use pl/sql and the DAC parameters but I do not believe you can replace the entire ETL process with just pl/sql and DAC.