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:
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.
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.