ds-blog-icon.png

THE DATA DOWNLOAD

As leaders in Enterprise Data Management and Business Intelligence, we pride ourselves on being able to deliver successfully on our projects as well as provide high-quality content to our readers.

Subscribe

Follow Us

facebook.png twitter.png linkedin.png youtube.png

Tom Nats

Recent Posts

Informatica Linux on SQL Server 2012

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

Topics: Tool Selection, Informatica, Blog, Informatica PowerCenter

By: Tom Nats

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


Read More

PowerCenter - Disable Repository Logging

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

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.


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

Sending an Email as Someone Else

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

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:

Read More