Informatica Cloud for Dummies - Informatica Cloud, Components & Applications

Informatica Cloud for Dummies - Informatica Cloud, Components & Applications

Informatica Cloud is an on-demand subscription service that provides cloud applications. When you subscribe to Informatica Cloud, you use a web browser to connect to Informatica Cloud. Informatica Cloud runs at a hosting facility.

Continue Reading

How to Use Error Handling Options and Techniques in Informatica PowerCenter

How to Use Error Handling Options and Techniques in Informatica PowerCenter

Data quality is very critical to the success of every data warehouse projects. So ETL Architects and Data Architects spent a lot of time defining the error handling approach. Informatica PowerCenter is given with a set of options to take care of the error handling in your ETL Jobs. In this article, lets see how do we leverage the PowerCenter options to handle your exceptions.

Continue Reading

How to Avoid The Usage of SQL Overrides in Informatica PowerCenter Mappings

How to Avoid The Usage of SQL Overrides in Informatica PowerCenter Mappings

Many Informatica PowerCenter developers tend to use SQL Override during mapping development. Developers finds it easy and more productive to use SQL Override. At the same time ETL Architects do not like SQL Overrides as it hide the ETL logic from metadata manager. In this article lets see the options available to avoid SQL Override in different transformations.

Continue Reading

Data Security Using Informatica PowerCenter Data Masking Transformation

Data Security Using Informatica PowerCenter Data Masking Transformation

You might have come across scenario where in you do not have enough good data in your Development and QA regions for your testing purpose; and you are not allowed to copy over data from production environment due to the data security reasons. Now using Informatica PowerCenter data masking transformation you can overcome such scenarios. In this article, lets see the usage of masking transformation.

Continue Reading

Transaction Control Transformation to Control Commit and Rollback in Your ETL

Transaction Control Transformation to Control Commit and Rollback in Your ETL

In a typical Informatica PowerCenter workflow data is committed to the target table after a predefined number of rows are processed into target, which is specified in the session properties. But there are scenarios in which you need more control on the commits and rollbacks.  In this article, lets see how we can achieve this using Transaction Control Transformation.

Continue Reading