Recent Informatica-Queries Posts from Tech Monger :///feeds/informatica-queries/ 2018-06-12T18:00:26.029866Z Werkzeug Informatica Workflow Details Repository Queries https://techmonger.github.io/33/informatica-workflow-queries 2018-06-12T17:56:02.264007Z 2018-06-12T17:53:45.211142Z Tech 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 Query https://techmonger.github.io/31/informatica-session-queries 2018-05-09T18:12:28.814319Z 2018-05-09T18:07:38.174272Z Tech 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 Queries https://techmonger.github.io/27/connection-details-repository 2018-03-06T17:32:26.919571Z 2018-03-06T17:21:43.053738Z Tech 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 Details https://techmonger.github.io/24/user-object-access 2018-06-12T18:00:26.029866Z 2018-01-26T13:34:36.726870Z Tech 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 & Queries https://techmonger.github.io/23/user-details-repository 2018-01-26T13:35:32.380727Z 2018-01-26T13:29:10.221245Z Tech 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>.