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.
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.
- 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.
Select the columns you want to use.
Click OK. A message box appears, which prompts you to do a
The guess query operation is needed only for the database metadata.
Click OK to close the message box. The
[Propagate] dialog box appears. Click
Yes to propagate the changes and close the dialog box.
On the Basic settings tab, click Guess
Query. The selected column names are displayed in the
Query area as expected.
For more information about how to set a repository schema, see Setting a repository schema in a Job.