Table of Contents

Search

  1. Preface
  2. Understanding Mapping Architect for Visio
  3. Mapping Templates
  4. Mapping Objects
  5. Mapping Template Rules
  6. Using the Import Mapping Template Wizard
  7. Using the mapgen Command Line Program
  8. Using Informatica Mapping Templates
  9. Appendix A: Glossary

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Lookup Transformation

Lookup Transformation

Use the Lookup transformation to look up data in a relational database. The Lookup transformation in a mapping template cannot use a flat file or a source qualifier as a lookup source.
If you use a Lookup transformation in a mapping template, you must manually export the lookup source. The Import Mapping Template Wizard does not export the source that the Lookup transformation references.
Configure the following required properties for the Lookup transformation:
Property
Cache Type
Description
Lookup Condition
All
The lookup condition must have the following syntax:
<LookupTableColumnName> <operator> <TransformationPort>
You can use one of the following operators or combination of operators:
=, <, <=, >, >=, !=
Do not use any other combination of operators. The following operators are invalid when you create mappings from the mapping template:
=>, =<, <>
Mapping Architect for Visio does not validate the Lookup condition. Ensure that you use the correct syntax for the condition.
Lookup table name
Table Name
Name of the table from which the transformation looks up and caches values.
Lookup source type
n/a
Source type of the Lookup transformation. The Lookup transformation must use a relational database source.
Input Ports
All
List of input ports. Separate entries with commas.
Comparison Ports
Dynamic Lookup Cache
List of associated input ports that the Integration Service uses to compare values.
Default values appear for many of the properties.

0 COMMENTS

We’d like to hear from you!