Using a repository schema partially in a Job - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
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
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

When using a repository schema, if you do not want to use all the predefined columns, you can select particular columns without changing the schema into a built-in one.

The following describes how to use a repository schema partially for a database input component. The procedure may vary slightly according to the component you are using.

Procedure

  1. Click the [...] button next to Edit schema on the Basic settings tab. The Edit parameter using repository dialog box appears. By default, the option View schema is selected.
    Edit parameter using repository dialog box.
  2. Click OK. The Schema dialog box pops up, which displays all columns in the schema. The Used Column check box before each column name indicates whether the column is used.
  3. Select the columns you want to use.
    Schema dialog box.
  4. Click OK. A message box appears, which prompts you to do a guess query.
    Note: The guess query operation is needed only for the database metadata.
  5. Click OK to close the message box. The Propagate dialog box appears. Click Yes to propagate the changes and close the dialog box.
    Propagate dialog box.
  6. On the Basic settings tab, click Guess Query. The selected column names are displayed in the Query area as expected.
    Basic settings view of the component.