Informatica help

Informatica help and metadata report query

Metadata Manager Reports

Metadata Manager Reports

This page will show you all the Available reports for Metadata Manager Reports, once you select a report name, it will open the report query page. copy and paste it to your PC and run it from, toad or any other DB tools you have.


Available reports

Business Intelligence

Report Name Description
Attributes and Metrics Lists all attributes and metrics by repository, schema, and dimension to which each attribute or metric belongs.
List of Hierarchies Lists the hierarchies in a schema.
Report Document Details(Attributes,Metrics) Lists attributes and metrics contained in the report documents.
Report Exploration Lists reports by repository and folder to which it belongs.
Schema Details (Attributes,Metrics) Lists attributes and metrics by repository, schema, and dimension to which each attribute or metric belongs.

Data Integration

Report Name Description
Powercenter Mappings by Folder Lists PowerCenter repository mappings by the folder in which each mapping resides.
Powercenter Workflows by Folder Lists PowerCenter repository workflows by the folder in which each workflow resides.

Data Modelling

Report Name Description
Constraints for a Table Lists constraints, such as Unique Key, Primary Key, Foreign Key, and Rule constraints, by the table for which the constraint is defined. It also provides the columns that participate in each constraint.
Table and Views Details (Column Level) Lists tables by Model, and table column information, such as name, precision, scale, and datatype.
Table and Views Summary Lists tables and views by Model.

Database Management

Report Name Description
Constraints for a Table Lists Database repository constraints, such as Unique Key, Primary Key, Foreign Key, and Rule constraints, by the table for which the constraint is defined. It also provides the columns that participate in each constraint.
Synonyms for Database Structures Lists database synonyms and the tables using those synonyms.
Tables, Views and Indexes Detail (Column Level) Lists the columns of database tables, views and indexes by schema.
Tables, Views and Indexes Summary (Column Level) Lists database tables, views and indexes by schema.

Metamodel/Metamodel Exploration

Report Name Description
Associations by Package Lists all associations in a specified package. Associations identify the relationship between classes in a metamodel.
Class Association Displays all attributes of the specified class, including its inherited attributes from parent classes.
Class Attribute Displays all attributes of the specified class, including its inherited attributes from parent classes.
Classes Exploration The Classes Exploration analytic workflow displays all classes in the metamodel and enables you to explore its contents, such as its attributes and packages.
Repository Instances List of Repository Instances
Repository Type Exploration The Repository Type Exploration analytic workflow displays all repository types in the metamodel and enables you to explore its contents, such as its packages and repository instances.

Metamodel/Metamodel Usage

Report Name Description
Element statistics Provides the total number of elements for each class in the specified repository instance.
Unused Classes by Repository Type Lists all classes that are not used by the metadata elements in the repositories of the specified repository type.

I hope you will enjoy the content of my website.
Please leave me a comment below if you have any suggestion for improving

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast