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 […]
December 24, 2016

Admin Console takes a lot of time while connecting from a VM image?

The usual case with the VM image is the slowness. As you are aware it depends on the allocated memory […]
December 24, 2016
Data Replication

We know that Data Warehouse is loaded from staging tables, then same data will be present at both the places for same time period, unnecessarily creating duplicate dataset. Can’t we have any other method to avoid this?

Its not always mandatory or true to have the same data in staging and in the Data Warehouse. You can […]
December 24, 2016

Junk Dimension – How would you design your DW tables if you had the date of each event instead of flags (Y/N) ? Would you still keep this dates within a junk dimension?

Sure, why not. But, as a best practice, it will not be included with the main junk dimension table (lets […]
December 24, 2016
multiple data stages

Instead of having multiple staging tables, can I stick with only one and do all my validations in the memory and insert the data to the star schema?

Yes, you can. End of it, these are relational and would work as we code and design them. We can […]
December 22, 2016

Informatica – Difference between Connected Lookup & Unconnected Lookup

December 22, 2016

All about SHORTCUTS in Informatica

There is always a main destination/target even if we use any shortcuts. In real world, using shortcuts to get something […]
December 22, 2016

What is a Global & Local Repository in Informatica?

All the technical metadata of Informatica Power Center is stored in the relational database and its called the repository. The […]
December 22, 2016
Transformations in Informatica

Brief about Informatica’s Transformations

Transformations help us to transform the source data according to the requirements of target system to ensure the quality of the […]
December 22, 2016

What is a Junk Dimension in Data warehouse?

As per Kimball Group, a junk dimension combines several low-cardinality flags and attributes into a single dimension table rather than modeling […]
December 22, 2016
Load Manager and DTM Process

Load Manager and Data Transformation Manager (DTM) Process

December 22, 2016

All you need to know about folders in Infromatica

Folders in Informatica Just like we create folders and organize content in our personal lives and work either physically or […]
December 22, 2016

How to Uninstall Informatica 8.6.1 in Windows?

Note: Please take all necessary back ups and code back ups before proceeding with the steps.  For any version beyond […]
December 22, 2016

What is Check In and Check Out in Informatica?

In Informaitca, from version 8x, we use Check in and Check out operations for versioning. Whenever there is a need […]