Creating triggers and filtering the data
Hi Team,
We have profile purchases for different subscribers,Every one hour we need to generate JSON and compare the purchases if there are any updates.
So to minimize the JSON generation and regeneration for the content comparison on the JSON files,We wanted to implement the triggers,In this context
1)JSON generation we will do though PL SQL routine
as per the dig,We want to configure the triggers and based on the updates we will copy staging table and then based on the UENS we will compare the content
Do we need single staging table for all triggers?OR multiple tables?