Source views provide you
all the information about the latest version of all source definitions defined by
folder of any PowerCenter repository. Also it gives all the fields and field
properties for all sources defined .It can be either relational or non
relational sources. Source views provide a wide range of information
about the source tables.
Source views give you much important information about source like:
Below listed are some of the
important Source views.
REP_ALL_SOURCES (provides
a list of the latest version of sources defined in each folder of a repository)
REP_ALL_SOURCE_FLDS (This
view provides all the fields and field properties for all sources)
Source views give you much important information about source like:
Source Repository Name(REP_ALL_SOURCES.REPOSITORY_NAME)
Source Database Name (REP_ALL_SOURCES .SOURCE_DATABASE_NAME)
Source Description (REP_ALL_SOURCES .SOURCE_DESCRIPTION)
Source Folder Name (REP_ALL_SOURCES .SUBJECT_AREA)
Source Schema Name (REP_ALL_SOURCES .PARENT_SOURCE_SCHEMA_NAME)
Source Field Name (REP_ALL_SOURCE_FLDS.SOURCE_FIELD_NAME)
Source Field Description (REP_ALL_SOURCE_FLDS. SOURCE_FIELD_DESCRIPTION)
No comments:
Post a Comment