Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 310 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 23 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Triggers being triggered by Data Flow "Save Data" to Database Table - How many times?
Question about saving data from DV via the Save Data to an existing Database Table with a trigger set on it:
Let's say you're writing a data flow dataset that will ultimately write 50 records to a table "TBL_SENT_FILES". That table has an after insert trigger on it to do some sort of task.
Will that trigger trigger once, or will it trigger 50 times?
Answers
-
You mean for a dataflow that will incrementally add data or replace the whole content?
You may want to enable auditing on your database and carefully analyse how it is performed…When replacing all the data in the table, the table is dropped, your trigger will be lost in the drop, a temporary table is created and finally renamed (at least last time I looked at it a year ago it was like this).
Incremental insertion I didn't check, but seeing how "unfriendly" the first test was, I can only highly encourage you to fully audit that process once to be sure of what's going on exactly (if you have an Oracle database, with unified auditing it is extremely easy to get a full list of what is performed on the table).
0
