Informatica Cloud does not have Rank Transformer as the Power Center (it is said to be coming in the first quarter of 2018). However, we can use Expressions to elegantly execute the rank transformation according to the specified columns. This is very similar to removing duplicates. It uses the concept …

Informatica Cloud does not have a remove duplicate stage where we can remove duplicate according to the specified column values. However, we can remove duplicate elegantly by using Sort and Expression Transformation. The most important concept about expressions is that Informatica follows the expression position to execute them. We have …

To expand the Type 1 Employee Dimension, we use the same Employee data to create a dimension table that captures historical changes in department and position. In this dimension, the change in the rest of the column (such as email address) will be simply updated. As discussed in the post, …

Implementing slowly changing dimension with Informatica Cloud requires a little bit of extra effort compared to DataStage or any other ETL tools that have a change capture stage or SCD stage. This example uses hashed values to find out which records are updated, inserted or deleted. We used the CRC32 …

In Informatica, Joiner and Lookup can both join tables according to the join keys. What are the difference between Joiner and Lookup? Joiner  Active Transformation The query cannot be overridden Works only for equal conditions Can do outer join Can use only as Source Multiple matches return all matching records …

This page explains how to join tables in Informatica Cloud with Joiner. In this example, we are adding Product Name and Unit Price to Sales_Record from Products by Product_Id. Sales_Record Products Steps Configure flat file connections to read both Sales_Records and Products. For flat file connection, see here. Product is …

This page explains how to create a connection to a directory from which you can read flat files in Informatica Cloud. (1) How to create a connection to a directory Go to the Conftion Tab and choose ‘Connection’   Add parameters (Connection Name, Type, Runtime Environment, Directory, Data Format and …