•  Preface
  •  Informatica Resources
    •  Informatica My Support Portal
    •  Informatica Documentation
    •  Informatica Web Site
    •  Informatica How-To Library
    •  Informatica Knowledge Base
    •  Informatica Support YouTube Channel
    •  Informatica Marketplace
    •  Informatica Velocity
    •  Informatica Global Customer Support
•  Introduction to Mapping Specifications
  •  Mapping Specifications Overview
  •  Mapping Specification Example
  •  Design Workspace
    •  Column Mapping Panel
    •  Properties Panel
    •  Data Preview Panel
    •  SQL Query Panel
    •  Profile Summary Panel
  •  Mapping Specification Types
    •  Mapping Specification Development
•  Mapping Specification Configuration
  •  Mapping Specification Configuration
  •  Creating a Mapping Specification
  •  Editing a Mapping Specification
  •  Map Source and Target Columns
    •  Mapping Source and Target Columns by Name or Position
    •  Mapping to Selected Columns
  •  Finding Columns
  •  Removing Column Relationships
  •  Mapping Specification Validation
    •  Validation Errors During Mapping Specification Development
    •  Validation Errors During Data Preview
    •  Validation Errors During a Load Operation to the Target
  •  SQL Query
    •  Adding an SQL Query
    •  Editing an SQL Query
•  Mapping Specification Objects
  •  Mapping Specification Objects Overview
  •  Mapping Specification Sources
    •  Adding and Editing a Source
  •  Mapping Specification Target
    •  Mapping Specification Target Datatypes
    •  Edit Options for Targets
    •  Editing the Target
  •  Mapping Specification Aggregators
    •  Aggregator Properties
    •  Adding and Editing a Simple Aggregator
    •  Adding and Editing an Advanced Aggregator
  •  Mapping Specification Rules
    •  Applying a Rule
    •  Creating a Mapping Specification Rule
    •  Rule Properties
    •  Editing a Reusable Rule
  •  Mapping Specification Filters
    •  Adding and Editing a Simple Filter
    •  Adding and Editing an Advanced Filter
  •  Mapping Specification Lookups
    •  Lookup Conditions
    •  Lookup Properties
    •  Adding a Lookup
    •  Editing a Lookup
  •  Mapping Specification Joins
    •  Adding and Editing a Simple Join
    •  Adding an Editing an Advanced Join
•  Mapping Specification Profiles
  •  Mapping Specification Profiles Overview
  •  Running a Column Profile
  •  Profile Summary
    •  Column Values
    •  Column Patterns
    •  Column Statistics
  •  Viewing Column Profile Results
•  Sharing Mapping Specification Logic
  •  Sharing Mapping Specification Logic Overview
  •  Mapping Specification Export to Microsoft Excel
    •  Exporting a Mapping Specification to Microsoft Excel
    •  Mapping Specifications in Microsoft Excel
  •  Mapping Specification Export to PowerCenter
    •  PowerCenter Repository Connection Properties
    •  Exporting a Mapping Specification to PowerCenter
  •  Mapping Specification Export as a Virtual Table
    •  Exporting a Mapping Specification as a Virtual Table
  •  Mapping Specification Export to a Table Definition
    •  Exporting a Mapping Specification to a Table Definition
  •  Loading Mapping Specification Results to a Table
  •  Loading the Results of a Mapping Specification to a Flat File
  •  Rules and Guidelines for Loading Mapping Specification Results to a Flat File

Preface

Rules and Guidelines for Loading Mapping Specification Results to a Flat File

MappingSpecification_Specifications

at_designworkspace_home

MappingSpecification_Properties

MappingSpecification_DataPreview

MappingSpecification_CreateSpecification

MappingSpecification_EditGeneral

MappingSpecification_automap

MappingSpecification_SqlQuery

MappingSpecification_EditSources

MappingSpecification_AddSource

MappingSpecification_EditTarget

MappingSpecification_AggregatorWizard

MappingSpecification_EditAggregator

MappingSpecification_AddOrEditRule

RuleProperties

RuleEditor_EditRuleGeneralView

RuleEditor_EditRuleExpressionView

RuleEditor_EditRulePortsView

MappingSpecification_EditSimpleFilter

MappingSpecification_EditAdvancedFilter

MappingSpecification_NewLookup

MappingSpecification_EditLookup

MappingSpecification_EditJoin

MappingSpecification_AddNewJoin

MappingSpecification_EditJoinConditions

MappingSpecification_ColumnProfiling

MappingSpecification_Export

MappingSpecification_ExportToExcel

MappingSpecification_ExportToPowerCenter

MappingSpecification_DeployAsSQLDataService

MappingSpecification_ExportToTableDefinition

MappingSpecification_LoadToTarget

MappingSpecification_ExportToFlatFile