Skip to Content
Author's profile photo Former Member

List of some Tables and Views in Data Service Repository

The metadata for the mappings created will get stored in the repository.

Data Services provides full access to the repository metadata used by the applications you create. To access this metadata either manually enters SQL SELECT statements or open the metadata reporting tool.

1. The following set of tables in the Data Services repository stores the statistics that the audit feature collects.12.PNG

2. The below set of tables (prefixed by AL_) and views (prefixed by ALVW_) will capture the information about the metadata imported into Data Services from external databases and applications (such as Oracle, PeopleSoft, and SAP ERP or R/3).

1.PNG

3. The below set of tables and views capture information about built-in metadata objects used by Data Services and the relationships between those objects.

13.PNG

4. These following tables and views contain information about the run-time statistics of Data Services jobs and data flows.

14.PNG

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good job prerna ,to represent it concisely.

      Keep Posting..

      Regards,

      Mayank

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Mayank..!!

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice information Prerna......... 🙂

      Regards,

      SM

      Author's profile photo Former Member
      Former Member

      Hi Prerna,

      Collective of table information is really appreciatable.

      Regards,

      J.Sakthikumar

      Author's profile photo Former Member
      Former Member

      Nice information.

      Author's profile photo Vivek Tripathi
      Vivek Tripathi

      Informative Post..

      Thanks for sharing...

      Author's profile photo Former Member
      Former Member

      Nice read