Informatica

Power Center Designer and Work flows in Informatica

Designer
Designer is GUI based client application which allows to create mappings which contain source and target definitions and transformation logics to move data from source to target.

  • A mapping is a logical representation of a data flow from source to target with rules defined.
  • Designer provides set of predefined rules which are called transformations to design the mappings.
  • Designer has various tools to create source, target definations, transformation rules to design source to target mappings.
  • It uses ODBC connection to import source and target defination from relational db. 
Designer Tools  

Source Analyzer
It is for import or create sources.
Target Designer
It is for import or creates targets
Transformation Developer
Develop transformations to use in mapping.
Mapplet Designer 
Create set of transformations to use in mapping.
Mapping Designer 
Create mappings that the integration service uses to extract transform and load data.

Workflow Manager
It is a GUI bsed application which allows to develop workflows to run the mappings and other related tasks.
  • A workflow is  a set of instructions that describes how and when to run tasks.
  • A task can be anything that is running of mapping,sending email, executing OS scripts.
  • We can also schedule the workflows when and how many times we want to run the workflow. 
Task Developer
It is used to create reusable tasks.
Worklet Designer
It is used to Create worklets. A worklet is an object that groups a set of tasks.
Workflows
It is for Create workflows.

Workflow Monitor
It is a GUI application which displays the status of workflow or task. 
  • It allows to run,stop,abort,and resume workflows.
  • We can view sessions and workflow log events.







Powered by Blogger.