Informatica Java Transformation to Leverage the Power of Java Programming

Informatica Java Transformation to Leverage the Power of Java Programming

Java is, one of the most popular programming languages in use, particularly for client-server web applications. With the introduction of PowerCenter Java Transformation, ETL developers can get their feet wet with Java programming and leverage the power of Java. In this article lets learn more about Java Transformation, its components and its usage with the help of a use case.

Continue Reading

Informatica Performance Tuning Guide, Identify Performance Bottlenecks - Part 2

Informatica Performance Tuning Guide, Identify Performance Bottlenecks - Part 2

In our previous article in the performance tuning series, we covered the basics of Informatica performance tuning process and the session anatomy. In this article we will cover the methods to identify different performance bottlenecks. Here we will use session thread statistics, session performance counter and workflow monitor properties to help us understand the bottlenecks.

Continue Reading

Session Logfile with Verbose Data for Informatica Mapping Debugging

Session Logfile with Verbose Data for Informatica Mapping Debugging

Debugger is a great tool to troubleshoot your mapping logic, but there are instances where we need to go for a different troubleshooting approach for mappings. Session log file with verbose data gives much more details than the debugger tool, such as what data is stored in the cache files, how variables ports are evaluated. Such information helps in complex tricky troubleshooting.

Continue Reading

Informatica Performance Tuning Guide, Tuning and Bottleneck Overview - Part 1

Informatica Performance Tuning Guide, Tuning and Bottleneck Overview - Part 1

Performance tuning process identifies the bottlenecks and eliminate it to get a better acceptable ETL load time. Tuning starts with the identification of bottlenecks in source, target, mapping and further to session tuning. It might need further tuning on the system resources on which the Informatica PowerCenter Services are running.

Continue Reading

Mapping Debugger to Troubleshoot your Informatica PowerCenter ETL Logic

Mapping Debugger to Troubleshoot your Informatica PowerCenter ETL Logic

Debugger is an integral part of Informatica PowerCenter mapping designer, which help you in troubleshooting the ETL logical error or data error conditions in an Informatica mapping. The debugger user interface shows the step by step execution path of a mapping and how the source data is transformed in the mapping. Features like "break points", "evaluate expression" makes the debugging process easy.

Continue Reading