Text-Only
Purdue Directory
ITaP People
About ITaP
Advanced Search
Connections & Accounts
Security Resources
Teaching & Learning
Business Technology
Research Computing
Shopping
Help & Support
PowerCenter Standards and Templates
ITaP Home
>
Business Technology
>
Standards and Templates
> PowerCenter Standards and Templates
IRM Links
Business Metadata Repository - BUMER
(PDF)
Data Access
Data Standards
Informatica PowerMart
Staff
PowerCenter ETL Standards
Standard PowerCenter ETL Process Flow
(Visio is required)
Process Flow Definitions
Informatica ETL Naming Standards
Standards for Cleaning up ETL Log and Bad Files
Naming Standards for ETL Templates
ETL UNIX Shell Scripting Standards
Error Handling in Workflows
PowerCenter Connection Objects Standards
PowerCenter ETL Helpful Hints
Best Practices When Building Maps
PowerCenter ETL Process Steps and Templates
1.0 - Define Requirements
Business Requirement Specification Template
2.0 - Create Physical Design
Business Requirement Specification Template
Mapping Specification Template
3.0 - Design Test Plan
ETL Test Plan Template
4.0 - Create ETL Process
ETL Object Migration Request Template
Mapping Specification Template
Database Object Migration Request Template
(if applicable)
5.0 - Test Process
ETL Test Plan Template
6.0 - Walkthrough ETL Process
ETL Mapping Walkthrough Template
7.0 - Coordinate Move to QA
ETL Object Migration Request Template
Database Object Migration Request Template
(if applicable)
Unix Job Setup Request Template
8.0 - Test Process
ETL Test Plan Template
9.0 - User Validates Data
Business Requirement Specification Template
10.0 - Coordinate Move to Production
ETL Object Migration Request Template
Database Object Migration Request Template
(if applicable)
Unix Job Setup Request Template
For circumstances where there are a large number of mappings to be implemented, use the ETL Object Migration Request Template at the workflow level, and attach any additional mapping information. The following links are examples of additional attachments:
Mapping Checklist
Implementation Plan
11.0 Maintain ETL Process
Business Requirement Specification Template
Mapping Specification Template
ETL Object Migration Request Template
Database Object Migration Request Template
(if applicable)
Unix Job Setup Request Template
PowerCenter ETL Template Field Definitions
Business Requirement Specification with description of fields
Mapping Specification Template with description of fields
ETL Test Plan Template with description of fields
ETL Object Migration Request Template with description of fields
Database Object Migration Request Template with description of fields
Unix Job Setup Request Template with description of fields
PowerCenter ETL Sample Templates
Sample Business Requirement Specification
Sample Mapping Specification
Sample ETL Test Plan
Sample ETL Object Migration Request Template
Sample Database Object Migration Request Template
Sample Unix Job Setup Request Template
Sample ETL UNIX Shell Script
PowerCenter Resources
Informatica's Website
(registration required)
Core Integration's Website
(Innercore Community - registration required)
Informatica Developer Network Home Page