Table of Contents

Search

Data Transformation Getting Started Guide

Data Transformation Getting Started Guide

Testing a Transformation - Tips

Testing a Transformation - Tips

Use the following tips to help you test a transformation more effectively.
Verify that the mapping logic is complete.
When you use the wizard to create a transformation, the wizard might create a complete transformation or a partial transformation. You might need to configure the transformation components to ensure that the mapping logic matches your requirements.
Verify that the Data Viewer is synched with the Editor.
For a transformation with a Script, Library, or XMap component, before you test a transformation in the
Data Viewer
view, verify that you synch the view with the editor. To verify that the
Data Viewer
view is synched, click the
Synchronize with Editor
button.
Check the output.
The Data Viewer view shows the entire output in an Output panel. You can scroll through the output file to verify that the transformation mapping logic works as you expect it to.
Use keyboard shortcuts.
You can use keyboard shortcuts to perform tasks in the Developer tool. To view the keyboard shortcuts, click
Help
Key Assist
.

Relational Input

Consider the following tips when you link relational input ports to hierarchical output nodes.
Link relational ports.
You can link an input relational port to a node in the hierarchy. You can link from an element in a hierarchical node to multiple relational groups in the input.
Link primary and foreign keys.
Link a primary key or foreign key from the relevant element or attribute in the hierarchy to a relational group in the input.
Ensure that ports have compatible data types.
When you link an input relational port and a hierarchical node, they must have compatible data types.