Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • Metadata Manager 10.5.5
  • All Products

Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Back Next

Metadata Object Properties

Metadata Object Properties

Metadata Manager extracts properties of PowerCenter metadata objects and stores their values in the Metadata Manager warehouse.
Metadata Manager truncates the value of an object property if the value is stored in multiple records. Metadata Manager extracts the value from the first record and then calculates the maximum size of the column attribute value to be extracted from the record.
Metadata Manager uses the following calculation to determine the maximum size of the column attribute value:
Maximum size of column attribute value = (extracted_value / codepage_factor) - 1
. Here, the extracted_value is the value from the first record and codepage_factor is the number of bytes per character used by the code page of the PowerCenter repository.
The following table shows the PowerCenter repository database and the corresponding number of first characters in the first record and the maximum size of the column attribute value:
Database
Number of Characters in the First Record
Maximum Size of Column Attribute Value
(PowerCenter Repository uses UTF-8 Code Page)
IBM DB2 for LUW
2,000
665
Microsoft SQL Server
4,000
1332
Oracle
2,000
665
Sybase
4,000
1332

Example

A PowerCenter repository resides on an IBM DB2 for LUW database and it contains an SQL override that is 5,000 characters long. The code page of the PowerCenter repository repository is UTF-8 and it uses three bytes per character.
PowerCenter performs the following tasks when you create a SQL override:
  1. Stores the SQL override metadata in three records in an IBM DB2 for LUW database table.
  2. As the IBM DB2 for LUW database can store up to 2,000 characters for each field, PowerCenter splits the 5,000-character SQL override metadata among three records.
    The first record contains the first 2,000 characters, the second record contains the next 2,000 characters, and the third record contains 1,000 characters.
  3. Metadata Manager calculates the maximum size of the column attribute value:
    (2000/3)-1 = 655
  4. Metadata Manager extracts 655 characters of SQL override metadata from the IBM DB2 for LUW database table.
0 COMMENTS
We’d like to hear from you!