...
Click "Next" to advance to the next stage of pipeline configuration.
The user will be directed to the Field Mapping Connection page
4. Mapping Source Attributes to Target Attributes
This screen provides the flexibility to map unstructured source attributes to structured target attributes. The attributes are referred to as fields here in this application
...
Auto Match: This is the default view as well – it acts as a name pair match (source fields will be mapped if it matches the same target field name)
Drag and Drop: You can drag a source field to the target field that you want to map to
Clear Mapping: It clears the existing mapping (i.e.: removes everything from the Mapped Field/Expression area
Search box: Using this you can find the field name
Delete a mapping: You can remove a mapping by clicking on the trash icon
FX: On click of a pop-up screen will open. Here you can add simple operations on your target data like :
Removing white spaces using Trim() , LTRIM(), RTRIM()
combine data of 2 source field to one target field using Concat(), OR
Set the desired date-format using To_Date()
Convert the other data types using TO_Float(), To_BigInt(), To_Char, To_Decimal(), To_Integer()
5. Configure Pipeline Scheduling
Access Scheduling Configuration: Navigate to the designated screen to configure scheduling for your pipeline based on business requirements
...
Upon clicking the "Done" button within the success message box, the application will navigate to the Manage Mapping page.
Note : -To explore more details on the read and save strategies for your data, kindly refer to the below link.