Mapping Fields for Data Transformation
Links fields from the file to BO attributes, applying transformation rules where needed.
- Field Identification: Review the data file for field names and positions (e.g., CustomerID, TransactionAmount).
- Define Field Mappings: In the File Request Type, define mappings for each field to its BO attribute.
- Apply Transformation Rules: Use formulas or predefined functions for complex mappings (e.g., concatenate FirstName and LastName to form FullName).
For example, the field CustName is split into FirstName
and LastName and stored as separate attributes.
