2012-04-22T18:39:00.000-07:00

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

2012-04-21T13:32:00.000-07:00

When do Database Partitioning in Informatica we have to make sure relational connection point database schema owner other wise it skip as pass through.

If you are request to create relational connection most of time admin create connection which is just for insert/read data, it not allow partitions from database side, Because that connection not point to Database owner which have all permission include partitions.