Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

Changing Data Movement Modes

Changing Data Movement Modes

You can change the data movement mode in the PowerCenter Integration Service properties in the Administrator tool. After you change the data movement mode, the PowerCenter Integration Service runs in the new data movement mode the next time you start the PowerCenter Integration Service. When the data movement mode changes, the PowerCenter Integration Service handles character data differently. To avoid creating data inconsistencies in your target tables, the PowerCenter Integration Service performs additional checks for sessions that reuse session caches and files.
The following table describes how the PowerCenter Integration Service handles session files and caches after you change the data movement mode:
Session File or Cache
Time of Creation or Use
PowerCenter Integration Service Behavior After Data Movement Mode Change
Session Log File (*.log)
Each session.
No change in behavior. Creates a new session log for each session using the code page of the PowerCenter Integration Service process.
Workflow Log
Each workflow.
No change in behavior. Creates a new workflow log file for each workflow using the code page of the PowerCenter Integration Service process.
Reject File (*.bad)
Each session.
No change in behavior. Appends rejected data to the existing reject file using the code page of the PowerCenter Integration Service process.
Output File (*.out)
Sessions writing to flat file.
No change in behavior. Creates a new output file for each session using the target code page.
Indicator File (*.in)
Sessions writing to flat file.
No change in behavior. Creates a new indicator file for each session.
Incremental Aggregation Files (*.idx, *.dat)
Sessions with Incremental Aggregation enabled.
When files are removed or deleted, the PowerCenter Integration Service creates new files.
When files are not moved or deleted, the PowerCenter Integration Service fails the session with the following error message:
SM_7038 Aggregate Error: ServerMode: [server data movement mode] and CachedMode: [data movement mode that created the files] mismatch.
Move or delete files created using a different code page.
Unnamed Persistent Lookup Files (*.idx, *.dat)
Sessions with a Lookup transformation configured for an unnamed persistent lookup cache.
Rebuilds the persistent lookup cache.
Named Persistent Lookup Files (*.idx, *.dat)
Sessions with a Lookup transformation configured for a named persistent lookup cache.
When files are removed or deleted, the PowerCenter Integration Service creates new files.
When files are not moved or deleted, the PowerCenter Integration Service fails the session.
Move or delete files created using a different code page.

0 COMMENTS

We’d like to hear from you!