December 25, 2018

What are the different Workflow/task status in PowerCenter?

In PowerCenter, the different workflow/task status is as follows:   Status Name Status for Description Aborted Workflows task​ You want […]
May 27, 2017

Is it a common practice that we use one Parameter file for one project for all workflows?

February 20, 2017
Sequence Generator Transformation

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

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 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 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
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 […]
November 1, 2016

How do object become impacted/invalid while migration and how can we re validate them?

There are multiple scenarios in which an object can become impacted/invalidated based on the changes done to the existing code […]
November 1, 2016

How can we roll back a deployment group?

Here are the steps to roll back a deployment. You can roll back a deployment and purge the deployed versions […]
July 21, 2016

Steps to change Password of Informatica Repository DB

Important points to note before this is done: Repository backup Please refer to the Optional and Required substitutions from the […]
January 9, 2016

FAQs for BI Architecture

What is a Data Warehouse? A data warehouse is a central repository for all or significant parts of the data […]