M2M AD301 Podręcznik Użytkownika Strona 175
- Strona / 230
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
Data Integration with Sybase Avaki Studio 163
Projection
Expression: Click in the column’s Expression field to edit it. This can be any
JavaScript expression, including simple column names from the incoming result
set. Click the “…” button to open the Edit Expression dialog if you need more
room than the table cell provides. You can also right click (either in the table cell
directly, or in the Edit Expression dialog) to show a context-sensitive menu of
column names, variables, and functions that you can paste into the Expression
field. For details on using JavaScript expressions, see “Using expressions within
Avaki Studio” on page 66. For details on the context menu, see “The expressions
menu” on page 71.
Type: Specify the type of the column. Be sure to specify a type that will match
the result of evaluating the column’s expression.
Precision: Specify the precision for the column, if applicable for the column’s
type.
Scale: Specify the scale for the column, if applicable for the column’s type.
Removing duplicates
Select the Generate only distinct (non-duplicate) rows checkbox to eliminate from
the output result set any rows whose data duplicates that of a row already in the output.
- Integration 1
- Avaki Studio 1
- Table of contents 3
- Creating view models 29 4
- The view model editor 53 4
- Metadata modeling 77 6
- Managing the data catalog 97 6
- Operator reference 107 6
- Glossary 175 8
- Audience 9
- Organization 10
- Related documentation 11
- By telephone 12
- On the web 12
- View models in Avaki Studio 13
- Background: Avaki concepts 14
- What is a view model? 14
- Data flow 16
- Expressions in operators 16
- Performance 17
- Operators 18
- Installing Avaki Studio 21
- Starting Avaki Studio 22
- Filename extension Purpose 23
- The Resource perspective 24
- Creating a project 26
- The Avaki perspective: A tour 29
- The data catalog view 30
- The palette 32
- The view model editor 33
- The metadata model editor 34
- The bottom pane 34
- Setting preferences 35
- Working with Avaki Studio 38
- Creating view models 41
- The exercise 42
- • SAL: The employee’s salary 43
- • dept_db 43
- • emp_db 43
- Creating database connectors 44
- Step 5 Fill in the form: 46
- SQL queries against the data 47
- SQL views. Ad-hoc queries 47
- Creating database operations 50
- Click Next 53
- Using the view model wizard 55
- Configuring input sources 56
- Joining result sets 57
- Step 9 Click OK 58
- Testing the view model 62
- EII Administration Guide 64
- Creating components 66
- XML-to-Result-Set transform 67
- HTTP requests or web ser 67
- Properties dialogs 70
- Working with schemas 72
- Types Precision Scale 74
- Using global parameters 75
- Adding global parameters 76
- Modifying global parameters 77
- Deleting global parameters 77
- Reordering global parameters 77
- Simple expressions 78
- Boolean expressions 78
- Complex expressions 79
- Expressions and JavaScript 79
- Accessing global parameters 80
- Working with variables 81
- Allowed types for variables 82
- The expressions menu 83
- Avaki Functions 85
- Advanced topics 87
- About metadata models 90
- Importing metadata models 91
- Designer 94
- AV M ) editor. It is 97
- Metadata modeling 100
- EMP table 101
- Deploying metadata models 103
- Deriving metadata models 105
- Deleting metadata models 106
- Undeploying metadata models 107
- Managing the data catalog 109
- Modifying ACLs 110
- Managing attributes 113
- Managing categories 116
- Adding objects to categories 117
- Deleting categories 118
- Operator reference 119
- Aggregate 120
- Aggregate properties 121
- Aggregate functions 122
- Connections 123
- Custom properties 124
- Generator 129
- Generator properties 130
- INTEGER 132
- Group By 133
- Performance notes 134
- Group By properties 134
- Input Source 137
- Input Source Properties 138
- On the next page (“Database 140
- • The entire SOAP response 147
- • No transform 148
- • CSV to Result Set 149
- • XML to Result Set 149
- XML document 152
- OK to save your changes 155
- Intersection 160
- Iterator 161
- Iterator properties 162
- Join properties 166
- Algorithm Description 167
- Join Type Description 168
- NULL values 168
- Multiplexer 169
- Multiplexer properties 170
- Order By 171
- Order By properties 172
- Projection 173
- Projection properties 174
- Result properties 176
- Select properties 177
- Splitter 178
- Splitter properties 179
- Union properties 181
- Update properties 183
- Glossary 187
- CIFS share 188
- CALL) that 192
- EII) A software system that 192
- EII) system provides secure 193
- CIFS shares 196
- SQL queries on the 198
- Master Index 199
- Index-2 Master Index 200
- Master Index Index-3 201
- Index-4 Master Index 202
- Master Index Index-5 203
- Index-6 Master Index 204
- Master Index Index-7 205
- Index-8 Master Index 206
- Master Index Index-9 207
- Index-10 Master Index 208
- Master Index Index-11 209
- Index-12 Master Index 210
- Master Index Index-13 211
- Index-14 Master Index 212
- Master Index Index-15 213
- Index-16 Master Index 214
- Master Index Index-17 215
- Index-18 Master Index 216
- Master Index Index-19 217
- Index-20 Master Index 218
- Master Index Index-21 219
- Index-22 Master Index 220
- Master Index Index-23 221
- Index-24 Master Index 222
- Master Index Index-25 223
- Index-26 Master Index 224
- Master Index Index-27 225
- Index-28 Master Index 226
- Master Index Index-29 227
- Index-30 Master Index 228
- Master Index Index-31 229
- Index-32 Master Index 230
© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.036 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji