A Translation is a Fabric Studio object that transforms data from one set of valid values to another in order to enable the execution of various transformation rules. Translation objects can be used as decision tables in Fabric and can be defined either on a Shared Objects level or on a Logical Unit level.
Go to Project Tree > Logical Units > [LU Name], right click Translations > New Translation to display the Translation Schema tab.
Define the Translation Schema:
Go to the Translation Data tab.
Optional: If the population data exists in a file or is retrieved from the DB, follow the instructions in How can I Import Translation Data.
To populate the data manually:
Click Save to display the New Item dialog box.
Complete the Name field and then click OK. Note the following:
The following Translation includes a list of Input and Output combinations where Input has unique values and Output values are repeated. For example, the Billing and Collection values of a LEGACY_ORD_TYPE Input field return the same Output value of BLG.
In the following Translation the Field Type = SQL whereby the query must be validated via the Query Builder.
To validate the query, click the SQL icon in the corner of the field and then click Execute Query in the Query Builder screen.
A Translation is a Fabric Studio object that transforms data from one set of valid values to another in order to enable the execution of various transformation rules. Translation objects can be used as decision tables in Fabric and can be defined either on a Shared Objects level or on a Logical Unit level.
Go to Project Tree > Logical Units > [LU Name], right click Translations > New Translation to display the Translation Schema tab.
Define the Translation Schema:
Go to the Translation Data tab.
Optional: If the population data exists in a file or is retrieved from the DB, follow the instructions in How can I Import Translation Data.
To populate the data manually:
Click Save to display the New Item dialog box.
Complete the Name field and then click OK. Note the following:
The following Translation includes a list of Input and Output combinations where Input has unique values and Output values are repeated. For example, the Billing and Collection values of a LEGACY_ORD_TYPE Input field return the same Output value of BLG.
In the following Translation the Field Type = SQL whereby the query must be validated via the Query Builder.
To validate the query, click the SQL icon in the corner of the field and then click Execute Query in the Query Builder screen.