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 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.
Step 5: Click on the "Execute" button to list the required objects and the output will be displayed as below.
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".
Step 3: From the file menu, go to "Tools" and select "Queries".
Note: - Use
these button to create a query.Step 5: Click on the "Execute" button to list the required objects and the output will be displayed as below.
Step 6: Click on the "Save" button to save the list. You can later process this data in to an Excel sheet.
Related links:
Interesting blog, here a lot of valuable information is available, it is very useful information informatica online training
ReplyDelete