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.
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).
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.
4. These following tables and views contain information about the run-time statistics of Data Services jobs and data flows.
Good job prerna ,to represent it concisely.
Nice information Prerna......... 🙂
Collective of table information is really appreciatable.
Thanks for sharing...
Is there any way in SAP BODS to find out which all dataflows are having pageable cache using any tables and Views in Data Service Repository