ODI Interview Questions and Answers:
Violation of PRIMARY KEY constraint 'PK_REV_COL'. Cannot insert duplicate key in object 'SNP_REV_COL'?
The SNP_REV_COL table which is stored in the current Work Repository is a temporary table that Oracle Data Integrator (ODI) uses during reverse engineering operations.
1. Temporarily disable the SNP_REV_COL primary key constraint.
2. In case customized reverse engineering was used, manually execute the query that ODI has generated for the "Get Columns" reverse engineering step (eg. with Squirrel).
3. Use the following query to identify the columns which are causing the problem:
select I_MOD, TABLE_NAME, COL_NAME, COUNT(*) as REPEATS
from SNP_REV_COL
group by I_MOD, TABLE_NAME, COL_NAME
order by COUNT(*) DESC, TABLE_NAME, COL_NAME
4. Note the TABLE_NAME and COL_NAME information for REPEATS greater than 1.
5. Enable the SNP_REV_COL primary key constraint.
Violation of PRIMARY KEY constraint 'PK_REV_COL'. Cannot insert duplicate key in object 'SNP_REV_COL'?
The SNP_REV_COL table which is stored in the current Work Repository is a temporary table that Oracle Data Integrator (ODI) uses during reverse engineering operations.
1. Temporarily disable the SNP_REV_COL primary key constraint.
2. In case customized reverse engineering was used, manually execute the query that ODI has generated for the "Get Columns" reverse engineering step (eg. with Squirrel).
3. Use the following query to identify the columns which are causing the problem:
select I_MOD, TABLE_NAME, COL_NAME, COUNT(*) as REPEATS
from SNP_REV_COL
group by I_MOD, TABLE_NAME, COL_NAME
order by COUNT(*) DESC, TABLE_NAME, COL_NAME
4. Note the TABLE_NAME and COL_NAME information for REPEATS greater than 1.
5. Enable the SNP_REV_COL primary key constraint.
No comments:
Post a Comment