M2M AD301 Podręcznik Użytkownika Strona 173
- Strona / 230
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
Data Integration with Sybase Avaki Studio 161
Projection
Projection
The Projection operator lets you modify a schema. You can pass certain columns
through, unaltered, you can remove columns completely, and you can create new col-
umns using arbitrary JavaScript expressions.
By default, Projection produces one row of output for every row of input. However,
you have the option of omitting duplicate rows from the output result set.
Connections
The Projection operator takes exactly one input result set, which can be the output of
an Input Source or of any other operator. It produces exactly one output result set
whose schema is defined by the operator.
Performance notes
In order to perform the “distinct” operation, Studio must sort the results of your pro-
jection, therefore similar performance issues apply as for the Order By operator. See
“Performance notes” on page 159 for details.
Required Connection
- 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.048 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji