THE DATA DOWNLOAD

Topics: Tool Selection, Informatica, Blog, Informatica PowerCenter

By: Tom Nats

With SQL Server 2012, Microsoft has included a much needed ODBC driver for Linux.

Topics: Tool Selection, Informatica, Blog, Informatica PowerCenter

Business Intelligence Review of 2013

By:  Steve Dine and David Crolene

Each year, we reflect upon the business intelligence (BI) and data integration (DI) industry and provide a Business Intelligence Review of the noteworthy trends that we encounter in the trenches.  Our Business Intelligence Review emanates from five sources: our customers, industry conferences, articles, social media, and BI software vendors.  This years Business Intelligence Review has proved to be an interesting one, on many fronts.  Here are our observations for 2012 and our expectations about 2013.

Topics: Tool Selection, Informatica, Blog, Informatica PowerCenter

By Tom Nats, Sr ETL Developer - Datasource Consulting

In Informatica 9.5 and prior, if you are running a workflow or a set of workflows continuously, you will fill up your repository very quickly. To avoid this, set this at at the integration service or at the session level under custom property.

Topics: Blog, Informatica PowerCenter

Sometimes as developers we find ourselves locked out of the Informatica PowerCenter environment preventing us from verifying if a particular folder, target, source or parameter file exists in the PowerMart directory. Using a Java Transformation provides a potential solution to this problem. The following will explain how to build a Java Transformation that takes as input the PowerMart root directory or any directory the Informatica PowerCenter account has access to and return information about all the files within the directory and its sub-directories as rows.

Topics: Informatica PowerCenter

Kept getting this error when trying to query the REP_SESS_TBL_LOG view in the PowerCenter repository:

ORA-01652: unable to extend temp segment by 64 in tablespace TEMP " in the database.

The stats were run (even though they were run the day before) and that didn't help.

Ran this command it fixed the issue:

Topics: Data Integration, Blog, Informatica PowerCenter

PowerCenter Workflows

Command-line tasks are great components that can facilitate reusability, standardization and scalability of processes tied to PowerCenter workflows. Building a library of reusable command tasks to be used throughout a Subject Area can be beneficial for such tasks as managing dependencies, tracking objects or interface/integrate with processes or tools external to PowerCenter.

Topics: Blog, Informatica PowerCenter

PowerCenter Tips

As an Informatica PowerCenter administrator, you may often have the need to obtain a list of users and associated groups, workflows that have last run, mappings in a folder, default values within a mapping, etc. This information can be queried in the PowerCenter tools, however, a more efficient way of collecting this data is to query the repository metadata tables directly in the database. This method proves to be very helpful when performing a large repository upgrade or decommissioning an environment.

Topics: Blog, Informatica PowerCenter

Sometimes when working with Informatica, you have to write a shell script or two (or three...). In those scripts, you might need to send an email on failure, etc..

To do this with the standard Linux client, you would use the following syntax: