M2M AD301 Uživatelská příručka stáhnout pdf (Strana 58)

Creating view models

46 Data Integration with Sybase Avaki Studio

Step 6 Double-click the Join operator to open the Join Properties dialog.

Step 7 Select the Sort Merge Join algorithm, the Inner join type, and set the outer table to

getEmpGivenName.

Step 8 In the Columns area of the properties dialog, specify one or more pairs of columns

whose values will be tested for equality. Each pair must include one column from the

outer table and one from the inner table. In this case, the common column is called

DEPTNO in both tables. Click Add to add a column. Use the pull-down menus to

select DEPTNO for both the inner and outer columns

Step 9 Click OK.

For more information on the Join operator, see “Join” on page 154.

1 2 ... 53 54 55 56 57 58 59 60 61 62 63 ... 229 230

Žádné komentáře

M2M AD301 Uživatelská příručka Strana 58