Configuring mappings for rejected data - 8.0

Talend Open Studio for Data Integration Getting Started Guide
Version
8.0
Language
English
EnrichDitaval
Open Studio for Data Integration
Product
Talend Open Studio for Data Integration
Module
Talend Studio
Content
Design and Development
Installation and Upgrade

This procedure shows how to configure mappings to gather rejected information.

Procedure

  1. Double-click the tMap component to open the map editor.

    An second output table named Invalid_movies has been automatically created.

  2. Drop the movieID and title columns from the row1 table to the Invalid_movies table.
  3. Click the tMap settings button on the Invalid_movies table, click the Value field for Catch lookup inner join reject, and then click the [...] button that appears to open the Options dialog box. In the dialog box, select true and click OK.

    With this setting, any records without director IDs or with director IDs that do not match with those in the reference file will be passed to this output.

  4. Click OK to validate the mappings and close the map editor, and click Yes when asked whether to propagate the changes.

    The mapping configurations are saved and the output schema is synchronized to the output component.

Results

Now you have configured mappings for the rejected output. Next, you'll need to configure the output components to write the output flows to database tables.