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

Transformation Restrictions

Transformation Restrictions

The following transformation restrictions apply when you import PowerCenter objects:
  • An expression in a transformation must contain 4,000 characters or fewer.
  • The database type for an SQL transformation converts to ODBC during the import process.
  • When you set the data cache size or the index cache size for a transformation to a value that is not valid, the import process changes the value to Auto.
  • When you import a mapping with an empty Lookup cache directory name into the Model repository, the imported mapping is not valid. To resolve this issue, enter a valid value for the Lookup cache directory name under the run-time properties for the Lookup transformation in the Developer tool.

0 COMMENTS

We’d like to hear from you!