March 8, 2017

What is the difference between Data Warehouse and Business Intelligence?

March 2, 2017
Sequence Generator Transformation

Possible cases of reverting the Sequence numbers of the Sequence Generator Transformation

February 21, 2017
Data Mining

Data Mining

February 20, 2017
Sequence Generator Transformation

How sequence can be used to assign missing values in a table?

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 […]