Designing the Job and configuring the input data - 6.5

Business rules

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Processing components (Integration) > Business rules components
Data Quality and Preparation > Third-party systems > Processing components (Integration) > Business rules components
Design and Development > Third-party systems > Processing components (Integration) > Business rules components
EnrichPlatform
Talend Studio

Procedure

  1. Drop a tFixedFlowInput and two tLogRow components from the Palette to the design workspace.
  2. From the Embedded Rules node in the Repository tree view, drop the rule template you created.
    A tRules component with the embedded rule template is displayed on the workspace.
  3. Link tFixedFlowInput to tRule using a Row > Main link.
  4. Double-click tFileInputDelimited to display its Basic settings view and define the component properties.
  5. Click the [...] button next to Edit schema to open the schema editor.
  6. Add two rows using the [+] button, name the rows as zipCode and CityName and click OK.
    When you define the DRL rules, you will use the zipCode column to match the city zip codes and the CityName column to output the name of the city that match the zip code.
    Note:

    Make sure to start the column name you will use to match the zip code with lower case, otherwise you will get an error when trying to run the Job.

  7. In the Mode area, select the Use Inline Content (delimited file).
  8. Set the row and field separators, and in the Content table, type in the delimited data on which to apply the DRL rules.