Informatica
Information is crucial part ,to get information from data has to work on data
Informatica is data handling tool .Having lots of transformation which include diffrent SQL function and procedure. One can say it is ETL tool which focus on data transformation form source to destination .
Informatica ETL programs designed in one of the client applications
(Designer or Workflow Manager) and are responsible for the whole ETL
process execution.
Informatica there are a few important objects definitions:
Mapping - developed in Designer, it logically defines the ETL process. Mappings read data from the sources, apply transformation logic to the data and write transformed data to targets.Transformations are elements of a mapping which generate, modify or pass the data. Transformations are linked together with links through ports (input and output) within a mapping.There are two groups of transformations: Passive - where the number of rows entering and exiting the transformation are the same (f.ex. Expression, Source Qualifier); Active - number of output rows may not be the same as input rows (f.ex. Aggregator).Examples of transformations: Source qualifier, expression, filter, sorter, aggregator, joiner, lookup, update strategy, router, transaction control, union.Task - designed in Workflow Manager, is an executable set of actions, functions or commands. A sequence of tasks defines the runtime behavior of an ETL process.Example: Session task runs a mapping, Command tasks executes a shell script, Email task sends an email.Workflow - designed in Workflow Manager, it is a collection of tasks that descibe runtime ETL processes. Tasks can be linked sequentially or concurrently and can also depend on the completion status of previous tasks.Each linked icon represents a task.http://etl-tools.info/informatica/programs.html
You can Get Details of Scenario about informatica from following link
|
