; Informatica Mapping Specifications Template
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Informatica Mapping Specifications Template

VIEWS: 1,087 PAGES: 5

  • pg 1
									                 ETL Mapping Specification
Mapping Name
Business
Requirement
Information


Source System                         Target System
Initial Rows                          Rows/Load
Short
Description
Refresh
Frequency
Preprocessing
Post Processing
Error Strategy
Reload Strategy
Unique Source
Fields


Sources

Tables
Table Name             Schema/Owner            Selection/Filter




Files
File Name              File Owner              Unique Key




                                          Page 1                  4/3/11
               ETL Mapping Specification
Targets

Tables         Schema Owner
Table Name     Insert   Update as    Update as     Update        Delete   Truncate   Unique
                        Update       Insert        else insert            Table      Key




Filter
/SQL
Over
ride



Files
File Name               File Owner                          Unique Key




Lookups

Lookup Name
Table                                            Location
Match
Condition(s)
Filter/SQL
Override




Lookup Name
Table                                            Location
Match
Condition(s)
Filter/SQL
Override


Lookup Name
Table                                            Location




                                                     Page 2                                   4/3/11
               ETL Mapping Specification
Match
Condition(s)
Filter/SQL
Override




                                    Page 3   4/3/11
               ETL Mapping Specification
Process Overview
To be used as a visual representation of the mapping

Processing Description (Detail)
Describe processing logic contained in mapping, including a description of the logic for each
transformation object.




                                                        Page 4                                  4/3/11
            ETL Mapping Specification
Source To Target Field Matrix

                                                                              Data
                                                                            Issues/
                                                                   Default Quality/
 Target   Target   Data-   Source   Source   Data-                 Value if Comme
 Table    Column   type     Table   Column   type     Expression    Null      nts




                                             Page 5                           4/3/11

								
To top
;