How to get Informatica Repository Information from Metadata

Updated on Dec 20, 2023

Some metadata views can be very handy to get Informatica Repository Information. Know How.

Following list of Informatica Metadata Repository Views can be used to quickly gather following repository information from the metadata:

Repository Name

Domain Name

Database User Name

List of Integration Services

Repository Folder Names

View details are provided below.

REP_REPOSIT_INFO

This view contains the list of the repositories. REP_REPOSIT_INFO has following important columns –

REPOSITORY_NAME: Name of the repository

REPOSITORY_DESCRIPTION: If any description is available

DOMAIN_NAME: Domain name e.g. PowerMart

DATABASE_USER: The username that Informatica uses to connect to database

REP_SERVER_INFO

This view contains the list of all integration services that are configured in the domain

REP_SUBJECT

This view contains the list of all the folders in Informatica Repository. REP_SUBJECT view has following important columns –

SUBJECT_AREA: Contains the folder name

DESCRIPTION: Contains the folder description if available

Informatica Metadata Tables - Overview and Tutorial

How to get Folders and Mapping names from Informatica Metadata Query

PrimeChess.org

PrimeChess.org makes elite chess training accessible and affordable for everyone. For the past 6 years, we have offered free chess camps for kids in Singapore and India, and during that time, we also observed many average-rated coaches charging far too much for their services.

To change that, we assembled a team of top-rated coaches including International Masters (IM) or coaches with multiple IM or GM norms, to provide online classes starting from $50 per month (8 classes each month + 4 tournaments)

This affordability is only possible if we get more students. This is why it will be very helpful if you could please pass-on this message to others.

Exclucively For Indian Residents:
Basic - ₹1500
Intermediate- ₹2000
Advanced - ₹2500

REP_REPOSIT_INFO

REP_SERVER_INFO

REP_SUBJECT

PrimeChess.org

Top 10 Articles