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.


Follow Us

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

Jerry Perez

Recent Posts

Informatica PowerCenter Directory Listing Using a Java Transformation

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

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.

Read More

Using PowerCenter Command-line Tasks: Manipulating Workflows

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

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.

Read More