How to create Repository Folder

Repository Folders Folders provide a way to organize and store metadata in the repository, including mappings, schemas, and sessions. Folders help you logically organize the repository. A folder consist of several objects that form power center code. Most of the objects created during the life cycle of the development are stored within the respective folders. … Continue reading How to create Repository Folder

Informatica Certification Developer Specialist

PowerCenter Data Integration 9.x: Developer, Specialist Certification This is Skill set Inventory document from Oracle website. Here you will get all the information which is required for the Informatica certification Perspective. About the Informatica Certified Professional (ICP) Program Informatica certification is a two-stage structure that correlates professional certification with the “what, why and how” of… Continue reading Informatica Certification Developer Specialist

PCSF_46008 Cannot connect to domain to lookup service – Informatica power center

You may experience this error while trying to connect to PowerCenter developer tools like Repository Manager, Designer, workflow Manager or workflow monitor. This error might be due to below two possible scenarios.  Your informatica service is not running your database connection password might have expired    Here is the steps to follow to make sure… Continue reading PCSF_46008 Cannot connect to domain to lookup service – Informatica power center

PowerCenter Express Overview

PowerCenter Express Overview — Its a single unified enterprise data integration platform. — Use PowerCenter Express to design and implement data integration solutions. — Use it to extract data from multiple sources, transform the data according to business logic, and load the transformed data to targets. (ETL) — PowerCenter Express includes the Informatica domain, clients, server and… Continue reading PowerCenter Express Overview

Informatica Transformations – Types

Types of Transformations  A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data. Transformations in a mapping represent the operations the Integration Service performs on the data.  Transformations can be of the… Continue reading Informatica Transformations – Types

Informatica Transformations – Overview

Transformation Overview A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. Transformations in a mapping represent the operations the Integration Service performs on the data. Transformations can be active or passive. Transformations can be connected to the data flow, or they… Continue reading Informatica Transformations – Overview