M2M AD301 Guia do Utilizador descarregar pdf (Página 60)

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)

1 2 ... 55 56 57 58 59 60 61 62 63 64 65 ... 229 230

Sem comentários

M2M AD301 Guia do Utilizador Página 60