February 20, 2017
Expression Transformation

Can Expression be used as Sequence transformation, if yes how?

February 18, 2017
Replicate entire informatica set up on another server

Steps to replicate entire Informatica set up on another server

February 17, 2017
Fact tables

Add columns to a fact table in the Data Warehouse

February 14, 2017
Sort the lists

Can we sort list of mapping and workflow by created date and time in folder?

February 10, 2017
SQL Developer Java Path

SQL Developer is not launching even after providing the Java path

This is one of the common issue which most of us face right after the SQL Developer is installed on […]
February 7, 2017
Fact Data

All you need to know about Facts and Types of Facts.

Lets start with the word called ‘granularity’ or ‘the grain’ first and then we understand the Fact. Later we will […]
February 1, 2017
Data Load Strategy

What is data load strategy for testing? How to perform it? and How to test full load and incremental load?

What is the Data Load Strategy? Depending on the phase in which you take this up the answer will vary. […]
January 31, 2017
database Schema

Which table should be loaded first? Fact or Dimensions?

Let’s understand this with an example.. If you have sales fact table which is loaded first with a record with a […]
January 27, 2017

If update override option is already in tgt instance why do we need upd strategy?

Update Strategy works only when you have primary key defined in the target table/ definition and when you want to […]
January 23, 2017

What is the difference between shortcut and reusable transformation?

A shortcut is a reference (link) to an object in a shared folder with in a repository, these are commonly […]
January 20, 2017

Transactional, Master and Reference Data explained

Transaction data keeps on changing and deals with day to day activities carried out in business or different departments. For […]
January 19, 2017
Data Extraction Methods

Different Data Extraction Methods in an Enterprise DataWarehouse

Online Extraction: In this method, the data is extracted directly from the Source for processing in the staging area (based […]
January 10, 2017

Load Balancing In Informatica

Load Balancing in Informatica is a mechanism which distributes the workloads across the nodes in the gird. Informatica has moved […]
January 10, 2017
Resilience Timeout

Difference between Resilience Timeout and Limit on Resilience Timeout

Lets understand these terms better before the answer. Resilience Timeout: The domain resilience timeout determines how long services attempt to […]
January 7, 2017
Repository Database

Use of an ODS in conjunction with a DWH

ODS plays a dual role, it is operational, providing high response time and availability and is certainly qualified to act […]
January 7, 2017
ODS vs Staging

Staging vs ODS

ODS can be considered as a staging area as the data can be stored here temporarily (about 45 to 60 […]
January 5, 2017

Concatenation of two active transformation

The Problem: You cannot connect multiple active transformations or an active and passive transformation to the downstream transformation or transformation […]
January 5, 2017
Data Cleansing

What is the actual difference between Data cleansing and Data scrubbing?

There can be many interpretations and often we get into a discussion/confusion that these are the same with different naming […]