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. […]
Read MoreTag: PowerCenter Express
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 […]
Read MorePCSF_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 […]
Read MorePowerCenter 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 […]
Read MoreInformatica 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 […]
Read MoreInformatica 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 […]
Read More