what is cascading trigger in Oracle?

Question

I want to implement the below scenario without using pl/sql procedure or unix script. I want to be implement by using Powercenter only.

Kindly suggest me.

1. I have a table called emp_details with columns (empno,ename,salary,emp_status,flag,date1) .
2. If someones updates the columns emp_status='abc' and flag='y' , Informatica WF 1 would be in continuous running status and checking emp_status value "ABC"
3. If it found record / records then query all the records and it will invoke WF 2.

4. WF 1 will pass value ename,salary,Date1 to WF 2 (Wf2 will populate will insert the records into the table emp_details2).

   Kindly tell me the informatica approach instead of plsql and shell script...

Answer 1

At times when SQL statement of a trigger can fire other triggers. This results in cascading triggers. Oracle allows around 32 cascading triggers. Cascading triggers can cause result in abnormal behavior of the application.

A Trigger that contains statements which cause invoking of other Triggers are known as cascading triggers. Here’s the order of execution of statements in case of cascading triggers:

Execute all BEFORE statement triggers that apply to the current statement.

Loop for each row affected statement.

Execute all BEFORE row triggers that apply to the current statement in the loop.

Lock and change row, perform integrity constraints check; release lock.

Execute all AFTER row triggers that apply to the current statement.

Execute all AFTER statement triggers that apply to the current statement.