Transformation logic

Transformation logic shows you the exact source code used to move or change your data. You can use this feature to trace data flows and find specific code fragments quickly. supports the most commonly used transformations.

To view the code for any table or column, right-click on a table or column in your lineage diagram, and then select Transformations (IN) to see code coming into the object, or Transformations (OUT) to see code going out.

The source code panetransformations viewer opens and shows:

• The name of the source code fragment. On the Sources tab page, you can see the analysis log files of this source code fragment.
• If a table or column has more than one transformation, there are tabs for each source code fragment.
• The source code of the fragment. The source code that is relevant for the selected column or table is highlighted.

For example, you want to see the outgoing transformations of column A to columns B and C. When you right-click column A and then click Transformations (OUT), you see that there are two tabs containing source code. The first tab shows the outgoing source code from column A to column B. The second tab shows the source code from column A to column C.