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 […]
December 22, 2016
STOP and ABORT in Informatica Power Center

Difference between Stop and Abort in Informatica – Real time examples

December 22, 2016

Types of Lookup Caches in Informatica

There is always quite some confusion on the different types of caches available for Lookup Transformation and which one to […]
December 22, 2016
Mapplet

Informatica Mapplet

December 22, 2016
Informatica Debugger

How to use Informatica debugger?

Informatica Debugger is to view the data changes or how the data changes through the logic implemented in a mapping. […]
December 22, 2016
Repository Database

All you need to know about Informatica Repository

A Repository in general is a container of information about all the objects and activities done within/by the tools. Informatica […]