Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Troubleshooting Mappings

Troubleshooting Mappings

When I save a mapping, the Designer indicates that it contains errors.
When you save a mapping, the Designer checks it for errors, such as targets that do not receive data from any sources. While you can save an invalid mapping, you cannot run a session using it.
The Designer does not allow me to connect two ports in a mapping.
The Designer performs validation when you connect ports. You cannot connect an input port to an input port, or two ports with incompatible datatypes. Check the error message displayed when the Designer prevented you from making the connection.
I cannot connect multiple sources to one target.
This is not allowed. These are possible workarounds:
  1. All targets are reusable. You can add the same target to the mapping multiple times. Then, connect each source qualifier to each target.
  2. Join the sources in a Source Qualifier transformation. Then, remove the WHERE clause from the SQL query.
  3. Join the sources in a Joiner transformation.
When I click and drag to create a connection between ports, the Designer copies the port instead.
Change the mode in which you are working by clicking Layout > Link Columns. Now, when you drag between columns, the Designer tries to link them instead of copying the selected port.
When I validate a mapping, I cannot see the results of the test.
Make sure that you have the Output window open when you validate the mapping. Click View > Output Window to see the results of the validation.
I entered a custom query, but it is not working when I run the workflow.
Be sure to test this setting for the source qualifier before you run the workflow. Return to the source qualifier and open the dialog box in which you entered the custom query. You can connect to a database and click the Validate button to test the SQL. The Designer shows you any errors exist that in the SQL you entered. Review the session logs if you need more information.

Updated July 02, 2020