Database and Informatica Capabilities

Database vs Informatica:

The project team should strive to make the optimum use of database and Informatica’s capabilities. Here are some of the scenarios where we can benefit from the strengths of Database and Informatica.

Database Functionality:

· Very Large Data Sets

· Sorts, Groups, Having (aggregations).

· Filtering, Distinct (qualifiers)

· Processing on the Server (without utilizing the network)

· Managed Batch application (where a BATCH of rows is affected in a single SQL statement)

· Bulk Loading

· Joins, and Mass Generation of new Sequence ID’s.

PowerMart / PowerCenter Functionality:

· Disparate Source System connections.

· Data Loading, including Bulk operations

· Column Manipulation (does not include CLEANSING, such as address cleansing).

· GUI Development

· Drag and Drop data flow design

· Source to Target mappings

· Implementation of business rules (column by column basis).

· Integration with multiple databases

· Management of all development work

· Fast prototyping

· Scheduling and multiple repository management