Control table is used to avoid full table scan when we need to check change in table (Insert new raw or change existing raw) or when we do CDC


Types of Control table:
1)    load control table : It store information of tables loaded data like table name, schema name, database name, start date of load, end date of load, no of raw added in last load, total no of raw etc.
        Naming :  LOAD_CNTL
2)    Informatica control table:  It contain information of informatica properties like workflow name, Status of workflow, dependent workflow, dependent sessions, no of session contain, target success raw etc..
        Naming : INF_CNTL