Recent Informatica-Queries Posts from Tech Monger:///feeds/informatica-queries/2018-06-12T18:00:26.029866ZWerkzeugInformatica Workflow Details Repository Querieshttps://techmonger.github.io/33/informatica-workflow-queries2018-06-12T17:56:02.264007Z2018-06-12T17:53:45.211142ZTech Monger<p class="lead">
Informatica stores basic workflow details inside repository view <code>REP_WORKFLOWS</code>. These details can come handy when you want to know information about workflow like when was workflow been last modified or current version of workflow. Below are the some of the useful columns from view <code>REP_WORKFLOWS</code>.
Informatica Session Details Repository Queryhttps://techmonger.github.io/31/informatica-session-queries2018-05-09T18:12:28.814319Z2018-05-09T18:07:38.174272ZTech Monger<p class="lead">
Often you need information about session runs which you can obtain by <a href="/30/session-stats/" title="Get Session Run Stats from Command Line">getsessionstatistics
Informatica Connection Details - Repository Querieshttps://techmonger.github.io/27/connection-details-repository2018-03-06T17:32:26.919571Z2018-03-06T17:21:43.053738ZTech Monger<p class="lead">
Often as an informatica power user or administrator you would need informatica connection details using script. Whenever user creates new connection inside informatica either through power center manager or using pmrep command the connection details get stored inside informatica repository database. To get those details using database query you can look inside table <code>OPB_CNX</code>, <code>OPB_CNX_ATTR</code>, <code>OPB_OBJECT_TYPE</code>, <code>OPB_MMD_CNX</code> and <code>OPB_MMD_CNX_ATTR</code>. Below are the some of the important columns from these tables.
Informatica Repository Query - Object Access Detailshttps://techmonger.github.io/24/user-object-access2018-06-12T18:00:26.029866Z2018-01-26T13:34:36.726870ZTech Monger<p class="lead">
Informatica stores details of users who have access over objects like workflow, mapping, session, connection etc. These details are stored inside repository table <code>OPB_OBJECT_ACCESS</code>. By querying this table you can fetch mapping between users and objects on which those users have access. Below are the details of the table.
Informatica User Details Repository Tables & Querieshttps://techmonger.github.io/23/user-details-repository2018-01-26T13:35:32.380727Z2018-01-26T13:29:10.221245ZTech Monger<p class="lead">
Whenever you create new user from admin console or infacmd Informatica stores user details into the repository tables. You can query this reopository table to get user details and can make join with access table to get <a href="/24/user-object-access/" title="Informatica user object access details">interaction details with different Informatica objects</a>. Informatica stores this details in following tables and views. We have listed them along with <em>only important and useful columns</em>.