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. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Import Performance

Import Performance

If you want to import mappings larger than 68 MB, import the mapping through command line for optimal performance. You can use the infacmd ipc ImportFromPC command to optimize import performance.
To improve performance during import from PowerCenter, you can add an option, -BlockSize to the infacmd ipc genReuseReportFromPC command.
Instead of importing every folder, you can import the required mappings from PowerCenter into the Model repository. Recommended Java heap size is 4 GB and blockSize is 100 for generating report especially if the user gets an out of memory error. You can also decrease the blockSize value in case of complex mappings.

0 COMMENTS

We’d like to hear from you!