Pages

Friday, August 22, 2014

Listing Informatica objects with Query Tool

Issue: List all Informatica objects(Mappings, Sessions, Workflows etc)

Solution: Use inbuilt "Queries" option in Informatica Powercenter Repository Manager tool.

Some of the uses of this "Queries" option.

a) Create list of objects such as Mappings, sessions, workflows etc.
b) Objects with their status( Valid or Invalid).

 In this post I will get the list of workflows in a particular folder using this option. Below are the steps to carryout this activity.

Step 1: Login to "Informatica Powercenter Repository Manager".


Step 2: From the file menu, go to "Tools" and select "Queries".

Tools and Queries option

Step 3: From the file menu, go to "Tools" and select "Queries".

Click New button to create a query

Step 4: Click on the "New" button to create a query and start composing a query like this.

Note: - Use  these button to create a query.

Query window


Step 5: Click on the "Execute" button to list the required objects and the output will be displayed as below.

Objects list output with informatica query tool

Step 6: Click on the "Save" button to save the list. You can later process this data in to an Excel sheet.

Save output list

Related links:


1 comment:

  1. Interesting blog, here a lot of valuable information is available, it is very useful information informatica online training

    ReplyDelete