...
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
...