Informatica SQL Transformation, SQLs Beyond Pre & Post Session Commands

Informatica SQL Transformation, SQLs Beyond Pre & Post Session Commands

SQL statements can be used as part of pre or post SQL commands in a PowerCenter workflow. These are static SQLs and can run only once before or after the mapping pipeline is run. With the help of SQL transformation, we can use SQL statements much more effectively to build your ETL logic. In this tutorial lets learn more about the transformation and its usage with a real time use case.

Continue Reading

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