Informatica is a company or corporation. The company provided different kinds of tools to perform ETL operations. Power Center is one of the powerful tool to perform ETL operations.
The informatica power center software divided into two parts.
1. Client
2. Server
In order to install server you need one database (Any Relational Database Eg:- Oracle). You can install client directly.
When you install power center client, you will get following tools automatically.
1. Power Center Designer
2. Power Center Workflow Manager
3. Power Center Workflow Monitor
4. Power Center Repository Manager
As informatica developer you are going to closely work with first three tools
Informatica Adminstrator is mainly used Power Center Repository Manager and Administration Console to perform all kinds of administration activities.
Power Center Designer
The Power Center Designer tool is used to
a) import source structures
b) import target structures
c) create reusable transformations
d) create reusable mapplets
e) create mappings
The Power Center Tool itself contain following tools
i) Source Analyzer: To create or import source structures
ii) Target Designer: To create or import target structures
iii) Transformation Developer: To create reusable transformations
iv) Mapplet Designer: To create mapplets
v) Mapping Designer: To create mappings
A mapping is nothing but logical representation of data flow, how to move data from source to target
Power Center Workflow Manager
The Power Center Workflow Manager tool is used to
a) Create sessions
b) Create different types of tasks such as command, email, decision, timer etc
c) Create worklets
d) Create workflows
The Power Center Workflow Manger itself contains following tools
i) Task Developer: To create session/command/email tasks
ii) Worklet Designer: To create worklets
iii) Workflow Manger: To create workflows and scheduling of workflows
Power Center Workflow Monitor
The Power Center Workflow Monitor tool is used to view the load statistics, how many rows read from source and how many rows loaded into target and how many rows entered into reject etc
There are two views under this Power Center Workflow Monitor
1. Ganttchart View
2. Task View
When you run a workflow automatically workflow monitor tool will open
Power Center Repository Manger
The Power Center Repository Manger tool is used for different kinds of tasks,
1. Creating folders
2. Managing Permissions
3. Export and Improt XMLs etc
The informatica power center software divided into two parts.
1. Client
2. Server
In order to install server you need one database (Any Relational Database Eg:- Oracle). You can install client directly.
When you install power center client, you will get following tools automatically.
1. Power Center Designer
2. Power Center Workflow Manager
3. Power Center Workflow Monitor
4. Power Center Repository Manager
As informatica developer you are going to closely work with first three tools
- Power Center Designer
- Power Center Workflow Manger
- Power Center Workflow Monitor
Informatica Adminstrator is mainly used Power Center Repository Manager and Administration Console to perform all kinds of administration activities.
Power Center Designer
The Power Center Designer tool is used to
a) import source structures
b) import target structures
c) create reusable transformations
d) create reusable mapplets
e) create mappings
The Power Center Tool itself contain following tools
i) Source Analyzer: To create or import source structures
ii) Target Designer: To create or import target structures
iii) Transformation Developer: To create reusable transformations
iv) Mapplet Designer: To create mapplets
v) Mapping Designer: To create mappings
A mapping is nothing but logical representation of data flow, how to move data from source to target
Power Center Workflow Manager
The Power Center Workflow Manager tool is used to
a) Create sessions
b) Create different types of tasks such as command, email, decision, timer etc
c) Create worklets
d) Create workflows
The Power Center Workflow Manger itself contains following tools
i) Task Developer: To create session/command/email tasks
ii) Worklet Designer: To create worklets
iii) Workflow Manger: To create workflows and scheduling of workflows
The Power Center tool comes under ETL tools. Generally ETL tool is used in DWH projects. As a ETL Devloper you need to understand DWH concepts also, interivew point of view also very important. Watch the below video and get more information.
When you try the job on informatica developer in the market, genertally they will ask questions on inforamtica and one database and unix.
Power Center Workflow Monitor
The Power Center Workflow Monitor tool is used to view the load statistics, how many rows read from source and how many rows loaded into target and how many rows entered into reject etc
There are two views under this Power Center Workflow Monitor
1. Ganttchart View
2. Task View
When you run a workflow automatically workflow monitor tool will open
Power Center Repository Manger
The Power Center Repository Manger tool is used for different kinds of tasks,
1. Creating folders
2. Managing Permissions
3. Export and Improt XMLs etc
Very useful information thank you for sharing.
ReplyDeleteInformatica Tutorial for Beginners
Very good post thank you for sharing. Take Informatica Data Quality Training and enhance your skills.
ReplyDelete
ReplyDeleteWorthful Informatica tutorial.Appreciate a lot for taking up the pain to write such a quality content on Informatica course. Just now I watched this similar Informatica tutorial and I think this will enhance the knowledge of other visitors for sure. Thanks anyway.:https://www.youtube.com/watch?v=JX2KkZNaKu0