Abu's Blog

Sub-Domain Area Architecture Pattern Name Design Patterns Solution Patterns Related Patterns Data Integration/SOA ETL ( Data Extraction Transformation & Loading) Change Data Capture Error handling EAI   Near Real-Time ETL Job scheduling Master Data Hub   Batch ETL Data validation Operational Data Store (ODS)   Data Discovery Slowly Changing Dimensions Load Datamart       […]

Trigger is a Program Unit generally a SQL statement or a set of SQL statements which executes automatically when an associated event of an object in a database occurs. This has basically three components Program unit is the automated predefined action item to be executed Object on which the action item will be associated Event […]