Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

REP_SRC_FILES

REP_SRC_FILES

This view provides a list of all file definitions in the repository. Use FIRST_FIELD_ID to retrieve the fields belonging to a non-relational source by following the links in the REP_SRC_FILE_FLDS view. Any flat file imported through the Source Analyzer has an entry.
The following table lists file information in the REP_SRC_FILES view:
Column Name
Datatype
Description
FILE_ID*
INTEGER
Source ID (primary key).
SUBJECT_AREA*
VARCHAR2 (240)
Folder name.
DATABASE_TYPE
VARCHAR2 (240)
Type of database extracted from.
DATABASE_NAME
VARCHAR2 (240)
Name of database extracted from (DSN).
FILE_NAME
VARCHAR2 (240)
Name of file definitions.
SCHEMA_FILE_NAME
VARCHAR2 (240)
File from which schema was extracted.
SELECT_INFO_ID
INTEGER
File organization information.
DISPLAY_SIZE
INTEGER
Display size (uncompressed).
PHYSICAL_SIZE
INTEGER
Physical size (compressed binary).
MIN_PHYSICAL_SIZE
INTEGER
Minimum physical size (varying records).
FIRST_FIELD_ID
INTEGER
Link to first field of file definitions.
SOURCE_DESCRIPTION
VARCHAR2 (2000)
Source description.
VERSION_ID
INTEGER
Version ID.
SOURCE_VERSION_NUMBER
NUMBER
Source version number.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!