User guide

Creating view models
48 Data Integration with Sybase Avaki Studio
Step 6 Double-click the Projection operator to open the Projection Properties dialog.
Step 7 Click Project All to carry in the columns from the input result set. Studio creates and
displays an output column for each column in the input.
Step 8 Click Add to add a new column.
Step 9 Click in the Name field of the new column and replace the default name with
NameNumberJob.
Step 10 In NameNumberJob’s Definition field, enter the following:
ENAME + " (" + EMPNO + "), " + JOB
Step 11 Leave the Type field set at VARCHAR, the default.
Step 12 Set the precision for NameNumberJob to 50.
Step 13 Select the following columns and use the Delete button to remove them:
• EMPNO
• ENAME
• JOB
• DEPTNO (remove only the bottom instance of DEPTNO)