PowerCenter provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store (ODS). You can extract data from multiple sources, transform the data according to business logic you build in the client application, and load the transformed data into file and relational targets.
some important terminologies in informatica are:
Repository Manager. You use the Repository Manager to create a folder to store the metadata you create in the lessons.
Designer. Use the Designer to create mappings that contain transformation instructions for the Integration Service. Before you can create mappings, you must add source and target definitions to the repository. In this tutorial, you use the following tools in the Designer:
- Source Analyzer. Import or create source definitions.
- Target Designer. Import or create target definitions. You also create tables in the target database based on the target definitions.
- Mapping Designer. Create mappings that the Integration Service uses to extract, transform, and load data.
Workflow Manager. Use the Workflow Manager to create and run workflows and tasks. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data.
Workflow Monitor. Use the Workflow Monitor to monitor scheduled and running workflows for each Integration Service.
Subscribe to:
Post Comments (Atom)
-
From yesterday onwards, I am stuck up with an error while trying to deploy cube. " You cannot deploy the model because the localhost ...
-
Common BI queries Relational queries Vs OLAP queries Before moving to terms used in Data warehouse, let us see the architect... -
Metadata is data about data.The word meta comes from Greek and means among,beside or after .It is like a card index describing how informa...
No comments:
Post a Comment