DESIGNER IN INFORMATICA

The Designer has five tools to help you build mappings and mapplets so you can specify how to move and transform data between sources and targets. The Designer helps you create source definitions, target definitions, and transformations to build your mappings.

The Designer allows you to work with multiple tools at one time and to work in multiple folders and repositories at the same time. It also includes windows so you can view folders, repository objects, and tasks.

Designer Tools

The Designer provides the 5 following tools:

Source Analyzer.

            Used to import or create source definitions for flat file (Fixed-width and delimited flat files), XML, COBOL, ERP, and relational sources (tables, views, and synonyms).

Warehouse Designer.

Used to import or create target definitions.

Transformation Developer.

           Used to create reusable transformations.

Mapplet Designer.

      Used to create mapplets.

Mapping Designer.

      Used to create mappings.