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
PowerCenter ETL Process Steps and Templates
1.0 - Define Requirements
2.0 - Create Physical Design
3.0 - Design Test Plan
4.0 - Create ETL Process
- ETL Object Migration Request Template
- Mapping Specification Template
- Database Object Migration Request Template (if applicable)
5.0 - Test Process
6.0 - Walkthrough ETL Process
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
9.0 - User Validates Data
10.0 - Coordinate Move to Production
- ETL Object Migration Request Template
- Database Object Migration Request Template (if applicable)
- Unix Job Setup Request TemplateFor 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