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 |