To Filter Source Data Using Runtime Inputs

1. Open the collaboration you want to edit.

2. Right-click the ETL Collaboration Editor window and select Runtime Inputs.

   The Add Input Runtime Arguments dialog box appears.

   

3. Click Add.

   An empty row appears.

4. Double-click the empty row under Argument Name and enter the name for source record to be filtered.

5. Press Tab and enter the content that the record must contain to be selected.

6. Press Tab and select the SQL type for the record.

7. Press Tab and enter a number indicating the maximum length of the record.

8. Press Tab and enter a number indicating the scale for the record.

9. Click OK.