Saturday 17 November 2012

Source Views In Informatica

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.

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

Related Posts Plugin for WordPress, Blogger...

ShareThis