Thoughts by: Dustin Goodyear February 28, 2017   Groundswell has been experiencing and participating in efforts towards a “Self Service/Specialists Not Required” model of integration for some time now. While providing our clients with solutions for non-technical developers and specialists is a common goal there are often hidden costs to having non-technical users implement and maintain a technical product/solution. It’s important when thinking about the benefits of the self-service model to plan for the many technical aspects that are still needed in these environments. Users without proper training invariably rely on the technical folks in IT to fix issues when […]

by Wade Lockhart February 21, 2017 Introduction In pt.1 of this blog I discussed an example of how to measure low performance using SQL queries both through Informatica and run manually against the repository database. In pt.2 I will be going over a few hints for improving repository performance along with their source. Disclaimer You should not try any of these hints without first consulting Informatica Support. You might also wish to take a full repository backup as well as a backup of the server environment before you begin the cleanup. Running some of these commands against a repository with […]

by Wade Lockhart February 14, 2017 Introduction This will be a two part blog which will discuss how to measure your Informatica repository performance (pt.1) and then provide some strategies for increasing performance (pt.2). Since this is pt.1, I will dive into the topic of ways to judge the performance of your repository. When I speak about performance of the repository, I mean a way to judge how responsive queries are against the repository. For example, if a query to fetch information from the repository takes x seconds through Informatica – that same query run from a client tool takes […]