Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Appendix A: Session Properties Reference
  17. Appendix B: Workflow Properties Reference

Workflow Basics Guide

Workflow Basics Guide

Overriding the SQL Query

Overriding the SQL Query

You can override the SQL query for a relational source.
  1. In the Workflow Manager, open the session properties.
  2. Click the Mapping tab and open the Transformations view.
  3. Click the Sources node and open the Properties settings.
  4. Click the Open button in the SQL Query field to open the SQL Editor.
  5. Enter the SQL override.
  6. Click OK to return to the session properties.

0 COMMENTS

We’d like to hear from you!