Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Data Type Conversion

Data Type Conversion

Some PowerCenter data types are not valid in the Model repository. When you import PowerCenter objects with data types that are not valid, the import process converts them to valid, comparable data types in the Model repository.
You cannot convert session parameters, workflow parameters, and workflow variables in PowerCenter into the Model repository. The import process maps all the parameter or variable references in the session to a string representation in the corresponding mapping task in the Model repository.
The following table lists the PowerCenter repository data types that convert to corresponding Model repository data type in the import process:
PowerCenter Repository Data Type
Model Repository Data Type
Real
Double
Small Int
Integer
Nstring
String
Ntext
Text

0 COMMENTS

We’d like to hear from you!