Extracting and filtering data

Procedure

In the design workspace, select tCombinedSQLInput and click the Component tab to access the configuration panel.
Enter the source table name, in this case employees in the Table field.
In the Schema field, select Repository from the list and click the [...] button right to the empty field to load the schema you saved.while configuring the settings for tFixedFlowInput.
In the Repository Content window, expand Generic schemas and select your schema.
Click the [...] button right to Edit schema.
Select View schema, and in the first column of the table, clear the check boxes for first_name, last_name and city.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!