How to Load Only the first row and last row from a file to a target file using aggregator

This post describes another way of loading the first and last rows. This time using the aggregator transformation. Please see my previous post if you want to know how to do this using a Rank Transformation.(Using Rank Transformation) Here we are going to use the default behaviour of the Aggregator transformation to get the last […]

How to load only the first and last row from a flat file to a target file using Rank transformation?

This is a common interview question which can really test the candidates’ knowledge of informatica transformations and logical thinking. The caveat here is you have to do this without using any pre-session commands So here we need to single out the first and last row from the source file. Lets take an example source file […]

How to run concurrent/multiple instances of an Informatica workflow?

By default Informatica workflows cannot be triggered again if they are already running. But there are scenarios where we need to trigger multiple instances of the same workflow. One such example could be when you need to load multiple source files through a single workflow, which gets triggered as soon as the file arrives. So […]

How to optimize lookup conditions for best performance?

Informatica lookup can contain several conditions to match incoming row with the lookup cache. The order of these conditions also determines how much time the lookup takes to match and return a row. For better performance follow below order to arrange your conditions to get the best performance out of your lookup transformation:- Equal to (=) […]

How to handle table or column names with reserved words in Informatica?

In Informatica, while querying a relational source using SQL overrides the session fails if you use words that are defined as keywords in the target database. for example words like USER, MONTH, YEAR etc are reserved keywords in many popular databases. These words are termed as reserved keywords. In order to query tables or columns with […]

What is a default lookup query and in which circumstances you should override it?

Informatica Integration service runs a default SQL statement when the first row enters the lookup transformation in the pipeline. Default Lookup Query If there is no SQL override and no filter specified the integration service generates a default SQL to query the lookup. It contains following components:- SELECT:- The select statement includes all the lookup ports […]

How to improve performance of a lookup by using “Pre-build Lookup Cache” option?

By default Informatica Integration service starts building the lookup cache only when the first input row is received by the lookup transformation during the session execution. This may sometimes cause the session to wait until the cache is build especially for large lookup files or complex lookup queries. In order to start building the lookup […]

What is a pipeline lookup and when to use it?

A pipeline lookup transformation uses a source qualifier as its source. It sources data from a source qualifier in a separate pipeline in the mapping. In this type of lookup you create an additional pipeline from the lookup source using a source qualifier. This pipeline does not contain any other transformation and is also called […]

Data Masking: Introduction to Key Masking

This type of data masking is used when a deterministic and repeatable output for a key value is needed. This means same input across multiple table columns will return the same output. It is helpful in maintaining the foreign key integrity across tables even when masking the key value. The controlling input is the seed […]

Introduction to Data Masking transformation in Informatica

Data Masking is a passive transformation added to Informatica version 8.6 which can be used to mask confidential data when transferring data to untrusted destinations. You pass in the columns to be masked to the input group and then configure the masking formats for each input port. The resulting output ports will contain data that […]