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
Hi Satish,
ReplyDeleteIt was very informative, thank you so much for that.
Could you please give tell me how to access control table in Informatica.
DO you have navigation path, if yes please share.
Thanks,
Gaurav
Gaurav,
DeleteControl table is just regulat table so there will be various way to access it with informatica, simple way I can think is create mapping as same source and target and pass parameters to Insert, Update and Read based on your requirement.
Does this helpful?