Informatica help

Informatica help and metadata report query

Mappings

Available reports

Report Name Description
All Objects Used in a Mapping Displays source, targets and all transformations used in a mapping by repository and folder.
Invalid Mapping sessions Displays sessions that are created for invalid mappings by repository and folder.
Invalid Mapping Targets Displays targets in an invalid mapping by repository and folder.
Invalid Mappings Displays invalid mappings by repository and folder.
Mapping List Displays mappings by repository and folder. It also displays properties of the mapping such as the number of sources used in a mapping, the number of transformations, and the number of targets.
Mapping Lookup Transformations Displays Lookup transformations used in a mapping by repository and folder.
Mapping Mapplets Displays mapplets used in a mapping by repository and folder.
Mapping Metadata Extensions Displays metadata extensions associated with a mapping and the properties of the metadata extensions.
Mapping Object-Level Connections Displays all transformations from source to target in a mapping and how they are connected to each other.
Mapping Port-Level Connections Displays all transformations from source to target in a mapping and how they are connected to each other through ports.
Mapping Shortcuts Displays mappings defined as a shortcut by repository and folder.
Mapping Source Field Details Displays column names for all sources by repository, folder, and mapping. It also displays properties of these columns such as datatype, precision, and length.
Mapping Sources Displays sources defined in a mapping by repository and folder.
Mapping Targets Displays targets defined in a mapping by repository and folder.
Mapping transformation Port Details Displays ports in a transformation by repository, folder, and mapping. It also displays properties of the ports. This report is the second node in a workflow associated with the Mapping List primary report.
Mapping transformations Displays transformations used in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping with no sessions Displays mappings that do not have any sessions defined by repository and folder.
Source to Target Dependency Displays the data flow from the source to the target by repository and folder. The report lists all the source and target ports, the mappings in which the ports are connected, the transformation expression that show how data for the target port is derived.