This is for beginners, who doesn’t even know that how Informatica power center looks like. So here is an attempt to give an over view for informatica power center. so one can visualize a bit about it.
You will not be able to build expertise after reading this. I would recommend taking up training from some professional institute to build expertise. Though It can be a nice pre-cursor to start training with some professional. My intention here is to tell that how one can relate it with other technologies.
Informatica power center gives you environment and that is known as Power center. Same as it happens in other technologies/tools, where you get few tools (GUI) which are generally called as development environment. Power center is also one integrated development environment where code can be written and tested.
Informatica power center is made of three parts. Each part has some sub part as well in it. But for now we will talk less. As discussing more in details can make it difficult and you might loose interest at very beginning. Just to start with, power center has three main components and they are Server, Repository and Client. For beginners a small description is provided below.
Power center ( Server ) :
After you write the code it is basically the server who takes care of instructions and executes them. So like other servers informatica server also works on client request and client can submit it by any means like manually , batch , scheduler or command prompt. So till now it was a very generic explanation. Making it to very specific to power center it looks like this- Power center extracts [Remember] the data from source, Transform [Remember] the extracted data and loads [Remember] the data to target. In other words power center does the job of ETL.
Power center ( Repository ) :
Like other technologies power center is little different and keeps the code in database. And database is called as Repository.it is generally a DB schema. Unlike java or dot net where code can reside in any type of file. Repository (Database) keeps so many other kind of information as well. For picture please refer below.
Power Center ( Client ) :
These are the tools provided by power center which helps to build logic, code and scheduler. There are four main client tools Designer, Work Flow manager, Monitor and Repository manager. With the help of these tools someone can create source , target , mappings , mapplets etc. Repository manager is generally used for creating users, folders , code migration etc.