Search code examples
informaticainformatica-powercenter

How to look for a specific mapping in the navigator window

I'm new to powercenter and the learning curve of this tool seems to be different from the programming languages I'm used to. Where I work everyone tells me to ask people in the office. Access to the internet is non existant. Stack overflow is one of the few places where I can look for info.

I would like to do something basic like, in the navigator window, there are sometimes thousands of mappings with veeeery similar names, I would like to know if there is a way to enable a "control-f" type of functionality. As of right now, placing the mouse on the window and writing the name kinda helps, but since the names are stuff like 

k_l_ll_sigpir_proyectname_mappingname

and there are dozens and hundreds that share the same structure: "k_l_ll_sigpir_" trying to navigate when you don't know where info is other than the name is a bit of a nightmare, compared to other tools at least.

Can someone point me in the right direction? Thanks in advance.

Solution

  • I guess I was able to find something that might help, although this is a bit counter-intuitive. I'm assuming you want to find and open some mapping in Mapping Designer. Here goes:

    1. After you've connected to Repository and have the right folder opened (not just connected!), choose Tools => Queries from the menu bar. A Query Browser should open for you.
    2. Choose New to create a new query
    3. In the Query Editor there's a grid. Choose Object Name in the Parameter Name column. Change the Operator to Contains and put whatever you're looking for as Value 1 (using your example: mappingname)
    4. Click the blue play button on the menu bar or choose Query => Execute from top menu. Give this a few seconds.
    5. Give it a few more seconds...
    6. A Query Results window should be opened for you. NOTE: if you've been clicking anything it might get opened in the background - just check the Designer button on Start Bar. It should contain all the objects that contain mappingname string it the name. We've not limited this to mappings only though (I'll discuss this below).

    === now here's the odd part ===

    1. You can right click any item on the list in Query Results window and choose Open in Workspace. And it won't work :)
    2. Switch back to Query Editor window and close it (don't close the Query Results!). You may save you'r query if you like to.
    3. You should be back at Query Browser. Close it.
    4. Return to Query Results.
    5. Right click the desired item and choose Open in Workspace.
    6. Voila!

    Now some remarks: The whole repository is searched. The Query Results may therefore contain items from other folders, than the one you have open. Trying to Open in Workspace such objects won't work since the folder is not open in Designer.

    You may construct more sophisticated queries. Just click 'Add new...' icon on the Query Editor window. This will add a line and allow you to choose extra conditions. It will be spawned by a AND condition which you may change to OR. You get the idea.

    PS. Yes, it's odd, I know. Just don't blame me ;)