User Guide > Using the Any-Any Transformation Editor > Transformation Editor Concepts
 
Transformation Editor Concepts
The Transformation Editor is an editor within TDV that can be used to define the transformation rules for the source data sets. It can transform data from any source structure to any target structure. The transformation of the data happens in real time as data is streamed, if possible, from the source to the target. The source and target are not persistent structures.
A transformation is a procedure in TDV and it can be used by other resources in TDV as a procedure. When caching is enabled on a transform, it is cached in the same way as any other procedure in TDV. It produces XQuery code that is used to execute the transformation. The XQuery code is not directly editable.
The Transformation Editor can map and transform data to and from the following:
Relational (Cursors)
XML (Hierarchies)
Scalar (Procedures)
You can also browse to and drag existing resources defined in Studio into the Transformation Editor. Concepts in other sections under this topic include:
The Transformation Editor Window
Transformation Editor Terminology
About Transformation Editor Operations and Parameter Containers
Transformation Editor Limitations