DataTransformations

In Informatica Master Data Management (MDM), the "C_REPOS" tables are core repository tables used to store configuration metadata and runtime information for the MDM Hub.

Job Control Tables:

Job Control Tables:
C_REPOS_JOB_CONTROL:- This table keeps track of information related to batch jobs, including job statuses, execution times, and control parameters: `SQL:- select * from c_repos_job_control where run_status=2; Conditions:- Run_Status = 2 --> Batch Job is Processing/Running. Run_Status = 0 --> Batch Job completed successfully. Run_Status = 1 --> Batch Job completed with Errors. Run_Status = 3 --> Batch Job Failed.` SQL- If Jobs which are stuck or Interrupted. `select * from c_repos_job_control where end_run_date is null and status_Message is null order by start_run_date desc;` C_REPOS_JOB_GROUP_CONTROL: This table stores the job runs that are triggered via Batch group job from the Hub Console. `SELECT * FROM c_repos_job_group_control ORDER BY start_run_date DESC;` C_REPOS_APPLIED_LOCK:- This table is used to manage and store information about locks applied to records during various operations. Column "LOCK_QUERY_SQL" will provide the details on which table lock is applied. `select * from c_repos_applied_lock where lock_query_sql like '%C_BO_PRTY%';`

C_REPOS_JOB_CONTROL:- This table keeps track of information related to batch jobs, including job statuses, execution times, and control parameters:

SQL:- select * from c_repos_job_control where run_status=2;
Conditions:-
Run_Status = 2 --> Batch Job is Processing/Running.
Run_Status = 0 --> Batch Job completed successfully.
Run_Status = 1 --> Batch Job completed with Errors.
Run_Status = 3 --> Batch Job Failed.

SQL- If Jobs which are stuck or Interrupted.

select * from c_repos_job_control where end_run_date is null and
          status_Message is null order by start_run_date desc;

C_REPOS_JOB_GROUP_CONTROL: This table stores the job runs that are triggered via Batch group job from the Hub Console.

SELECT * FROM c_repos_job_group_control ORDER BY start_run_date DESC;

C_REPOS_APPLIED_LOCK:- This table is used to manage and store information about locks applied to records during various operations. Column "LOCK_QUERY_SQL" will provide the details on which table lock is applied.

select * from c_repos_applied_lock where lock_query_sql like '%C_BO_PRTY%';

Informatica MDM Job Control Tables: Essential SQL Queries for Daily Operations