INFORMATICA Repository SQL-Collection

TABLE OF CONTENTS

1 Overview

2 FOLDER
2.1 List folder details
2.2 List of shared folders
2.3 List of Users and Groups having Privileges on Folders

3 SOURCE
3.1 List of source tables
3.2 List and count of tables in each folder by db type
3.3 List and count of tables overall used
3.4 List of source tables used in mappings
3.5 List of Sources tables using as Shortcuts

4 TARGET
4.1 List of Target Tables
4.2 List and count of tables in each folder by db type
4.3 List and count of table overall used

5 TRANSFORMATION
5.1 List of filer transformations
5.2 List of Sequence transformations
5.3 List of tables used as lookups
5.4 List of transformations using sql overrides
5.5 List all transformations
5.6 List all Expression transformations using ‘concat’ function
5.7 List of all port details of an Expression transformations
5.8 List of all Expression transformation port links
5.9 List of LKP transformation port links used in mappings

6 MAPPING
6.1 List mapping names
6.2 List total count of mappings
6.3 List last saved user for a mapping

6.4 List Mapping parameters and variables
6.5 List all Mappings using PARALLEL hints

7 MAPPLET
7.1 List Mapplets in all folders
7.2 List Mapplet parameters and variables

8 SESSION
8.1 List session names
8.2 List save session log count
8.3 List stop on errors count
8.4 List hardcoded paths
8.5 List parameter file paths
8.6 List session log names
8.7 List commit intervals
8.8 List total source partitions
8.9 List total target partitions
8.10 List DTM Buffer Size
8.11 List collect performance data
8.12 List Incremental Aggregation
8.13 List Reinitialize aggregate cache
8.14 List Enable high precision
8.15 List Session retry on deadlock
8.16 List write backward compatible check
8.17 List over ride tracing
8.18 List save session log by
8.19 List load type
8.20 List ‚post_session_success_command‘ in session
8.21 List of all emails with attachment
8.22 List Invalid Sessions and Workflows

9 TASKS
9.1 List command tasks
9.2 List decision tasks
9.3 List Event Wait tasks

10 WORKLET
10.1 List worklet names
10.2 List hierarchies of all workflows and its worklets

11 WORKFLOW
11.1 List workflow names
11.2 List save workflow log count
11.3 List workflow log names
11.4 List write backward compatible check
11.5 List fail_parent_if_task_fails objects
11.6 List fail_parent_if_task_dont_run objects
11.7 List is_task_enabled objects
11.8 List treat_input_links_as objects
11.9 List all workflows whose server is not assigned
11.10 List of workflow run details

12 CONNECTIONS
12.1 List of cnxs using alter in env sql
12.2 List of cnxs used in session levels
12.3 List Lotus connection details
12.4 ODBC / SQL Server Connection details
12.5 List of sessions used by a connection
12.6 List all Connections with User and Privileges

13 REPOSITORY
13.1 Repository Info
13.2 List of objects which are Not Valid
13.3 List of objects which are failed in last 5 days
13.4 List where all a table is used
13.5 List all source and target tables of mapping
13.6 List Comments of all objects

14 MISCELLANEOUS
14.1 Query to find list of all objects saved by what user

15 GROUPS & USERS
15.1 List User, Groups and status