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.
| Data Model Repos Tables |
C_REPOS_TABLES: Stores metadata about all the tables in the MDM Hub.
C_REPOS_COLUMNS: Contains metadata about the columns in each table.
C_REPOS_INDEXES: Holds information about indexes created on the tables.
SQL:- select * from c_repos_table where type_ind=1;
Conditions:-
type_ind=1 for Base Object Tables
type_ind=2 for Staging Tables
type_ind=3 for Internal System Tables
type_ind=4 for Lookup Tables
type_ind=5 for Cross-Reference Tables
To learn more about objects in the ORS Data Model, including Base Object tables and their corresponding columns, data types, and lengths, use the following SQL query.SQL:- select
t.table_name,
t.display_name,
c.column_name,
case when c.column_name like '%ROWID_OBJECT%'
then 'Rowid_object'
else c.display_name
end column_display_name,
case when c.column_name like '%ROWID_OBJECT%'
then 'Y' end pk,
c.data_type,
c.data_length
From c_repos_table t
inner join c_repos_column c on t.table_name=c.table_name
where t.type_ind=1
order by t.table_name;
|
