ds-blog-icon.png

THE DATA DOWNLOAD

As a business intelligence consulting company, we pride ourselves on being able
to deliver on our projects as well as provide good quality content to our readers.

Informatica Linux on SQL Server 2012

Dec 20, 2016 10:10:44 AM   Tom Nats

Topics: Blog, Tool Selection, Informatica, Informatica PowerCenter

By: Tom Nats

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


Read More

Business Intelligence Review from the Trenches - 2013

Dec 20, 2016 10:07:48 AM   Steve Dine & David Crolene

Topics: Blog, Tool Selection, Informatica, 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.


Read More

PowerCenter - Disable Repository Logging

Dec 20, 2016 10:05:29 AM   Tom Nats

Topics: Blog, Tool Selection, Informatica, 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.


Read More

Informatica PowerCenter Directory Listing Using a Java Transformation

Apr 25, 2016 1:53:10 PM   Jerry Perez

Topics: Informatica PowerCenter, Blog

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.

Read More

ORA-01652 Informatica

Apr 25, 2016 1:52:56 PM   Tom Nats

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:

Read More

Using PowerCenter Command-line Tasks: Manipulating Workflows

Apr 25, 2016 1:52:39 PM   Jerry Perez

Topics: Informatica PowerCenter, Blog, Data Integration

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.

Read More

Querying the Informatica PowerCenter Repository

Apr 25, 2016 1:52:05 PM   Sally McCormack

Topics: Informatica PowerCenter, Blog

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.

Read More

Sending an Email as Someone Else

Apr 25, 2016 1:51:07 PM   Tom Nats

Topics: Informatica PowerCenter, Blog

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:

Read More