Recently I faced with a unique problem when trying to upgrade repositories from version 10 to version 11. For some reason the upgrade utility wasn't able to find the connected Work Repositories and the older version of ODI was messed up so it wasnt opening.
To view all the details of Schemas and Connections made, you need to look at the SNP_CONNECT table of master repository. It contains all the information of the physical connections that can be crucial when recovering corrupted repositories.
Attaching an image of SNP_CONNECT table (reversed in ODI)
To view all the details of Schemas and Connections made, you need to look at the SNP_CONNECT table of master repository. It contains all the information of the physical connections that can be crucial when recovering corrupted repositories.
Attaching an image of SNP_CONNECT table (reversed in ODI)
No comments:
Post a Comment