/database/metadata_dev/layer_index_link_analysis.ktr
Unknown | 792 lines | 773 code | 19 blank | 0 comment | 0 complexity | 50c67ca82bdf28d6b7b58d0b85eb981d MD5 | raw file
1<?xml version="1.0" encoding="UTF-8"?> 2<transformation> 3 <info> 4 <name>layer_index_link_analysis</name> 5 <description/> 6 <extended_description/> 7 <trans_version/> 8 <trans_type>Normal</trans_type> 9 <directory>/</directory> 10 <parameters> 11 </parameters> 12 <log> 13<trans-log-table><connection/> 14<schema/> 15<table/> 16<size_limit_lines/> 17<interval/> 18<timeout_days/> 19<field><id>ID_BATCH</id><enabled>Y</enabled><name>ID_BATCH</name></field><field><id>CHANNEL_ID</id><enabled>Y</enabled><name>CHANNEL_ID</name></field><field><id>TRANSNAME</id><enabled>Y</enabled><name>TRANSNAME</name></field><field><id>STATUS</id><enabled>Y</enabled><name>STATUS</name></field><field><id>LINES_READ</id><enabled>Y</enabled><name>LINES_READ</name><subject/></field><field><id>LINES_WRITTEN</id><enabled>Y</enabled><name>LINES_WRITTEN</name><subject/></field><field><id>LINES_UPDATED</id><enabled>Y</enabled><name>LINES_UPDATED</name><subject/></field><field><id>LINES_INPUT</id><enabled>Y</enabled><name>LINES_INPUT</name><subject/></field><field><id>LINES_OUTPUT</id><enabled>Y</enabled><name>LINES_OUTPUT</name><subject/></field><field><id>LINES_REJECTED</id><enabled>Y</enabled><name>LINES_REJECTED</name><subject/></field><field><id>ERRORS</id><enabled>Y</enabled><name>ERRORS</name></field><field><id>STARTDATE</id><enabled>Y</enabled><name>STARTDATE</name></field><field><id>ENDDATE</id><enabled>Y</enabled><name>ENDDATE</name></field><field><id>LOGDATE</id><enabled>Y</enabled><name>LOGDATE</name></field><field><id>DEPDATE</id><enabled>Y</enabled><name>DEPDATE</name></field><field><id>REPLAYDATE</id><enabled>Y</enabled><name>REPLAYDATE</name></field><field><id>LOG_FIELD</id><enabled>Y</enabled><name>LOG_FIELD</name></field></trans-log-table> 20<perf-log-table><connection/> 21<schema/> 22<table/> 23<interval/> 24<timeout_days/> 25<field><id>ID_BATCH</id><enabled>Y</enabled><name>ID_BATCH</name></field><field><id>SEQ_NR</id><enabled>Y</enabled><name>SEQ_NR</name></field><field><id>LOGDATE</id><enabled>Y</enabled><name>LOGDATE</name></field><field><id>TRANSNAME</id><enabled>Y</enabled><name>TRANSNAME</name></field><field><id>STEPNAME</id><enabled>Y</enabled><name>STEPNAME</name></field><field><id>STEP_COPY</id><enabled>Y</enabled><name>STEP_COPY</name></field><field><id>LINES_READ</id><enabled>Y</enabled><name>LINES_READ</name></field><field><id>LINES_WRITTEN</id><enabled>Y</enabled><name>LINES_WRITTEN</name></field><field><id>LINES_UPDATED</id><enabled>Y</enabled><name>LINES_UPDATED</name></field><field><id>LINES_INPUT</id><enabled>Y</enabled><name>LINES_INPUT</name></field><field><id>LINES_OUTPUT</id><enabled>Y</enabled><name>LINES_OUTPUT</name></field><field><id>LINES_REJECTED</id><enabled>Y</enabled><name>LINES_REJECTED</name></field><field><id>ERRORS</id><enabled>Y</enabled><name>ERRORS</name></field><field><id>INPUT_BUFFER_ROWS</id><enabled>Y</enabled><name>INPUT_BUFFER_ROWS</name></field><field><id>OUTPUT_BUFFER_ROWS</id><enabled>Y</enabled><name>OUTPUT_BUFFER_ROWS</name></field></perf-log-table> 26<channel-log-table><connection/> 27<schema/> 28<table/> 29<timeout_days/> 30<field><id>ID_BATCH</id><enabled>Y</enabled><name>ID_BATCH</name></field><field><id>CHANNEL_ID</id><enabled>Y</enabled><name>CHANNEL_ID</name></field><field><id>LOG_DATE</id><enabled>Y</enabled><name>LOG_DATE</name></field><field><id>LOGGING_OBJECT_TYPE</id><enabled>Y</enabled><name>LOGGING_OBJECT_TYPE</name></field><field><id>OBJECT_NAME</id><enabled>Y</enabled><name>OBJECT_NAME</name></field><field><id>OBJECT_COPY</id><enabled>Y</enabled><name>OBJECT_COPY</name></field><field><id>REPOSITORY_DIRECTORY</id><enabled>Y</enabled><name>REPOSITORY_DIRECTORY</name></field><field><id>FILENAME</id><enabled>Y</enabled><name>FILENAME</name></field><field><id>OBJECT_ID</id><enabled>Y</enabled><name>OBJECT_ID</name></field><field><id>OBJECT_REVISION</id><enabled>Y</enabled><name>OBJECT_REVISION</name></field><field><id>PARENT_CHANNEL_ID</id><enabled>Y</enabled><name>PARENT_CHANNEL_ID</name></field><field><id>ROOT_CHANNEL_ID</id><enabled>Y</enabled><name>ROOT_CHANNEL_ID</name></field></channel-log-table> 31<step-log-table><connection/> 32<schema/> 33<table/> 34<timeout_days/> 35<field><id>ID_BATCH</id><enabled>Y</enabled><name>ID_BATCH</name></field><field><id>CHANNEL_ID</id><enabled>Y</enabled><name>CHANNEL_ID</name></field><field><id>LOG_DATE</id><enabled>Y</enabled><name>LOG_DATE</name></field><field><id>TRANSNAME</id><enabled>Y</enabled><name>TRANSNAME</name></field><field><id>STEPNAME</id><enabled>Y</enabled><name>STEPNAME</name></field><field><id>STEP_COPY</id><enabled>Y</enabled><name>STEP_COPY</name></field><field><id>LINES_READ</id><enabled>Y</enabled><name>LINES_READ</name></field><field><id>LINES_WRITTEN</id><enabled>Y</enabled><name>LINES_WRITTEN</name></field><field><id>LINES_UPDATED</id><enabled>Y</enabled><name>LINES_UPDATED</name></field><field><id>LINES_INPUT</id><enabled>Y</enabled><name>LINES_INPUT</name></field><field><id>LINES_OUTPUT</id><enabled>Y</enabled><name>LINES_OUTPUT</name></field><field><id>LINES_REJECTED</id><enabled>Y</enabled><name>LINES_REJECTED</name></field><field><id>ERRORS</id><enabled>Y</enabled><name>ERRORS</name></field><field><id>LOG_FIELD</id><enabled>N</enabled><name>LOG_FIELD</name></field></step-log-table> 36 </log> 37 <maxdate> 38 <connection/> 39 <table/> 40 <field/> 41 <offset>0.0</offset> 42 <maxdiff>0.0</maxdiff> 43 </maxdate> 44 <size_rowset>10000</size_rowset> 45 <sleep_time_empty>50</sleep_time_empty> 46 <sleep_time_full>50</sleep_time_full> 47 <unique_connections>N</unique_connections> 48 <feedback_shown>Y</feedback_shown> 49 <feedback_size>50000</feedback_size> 50 <using_thread_priorities>Y</using_thread_priorities> 51 <shared_objects_file/> 52 <capture_step_performance>N</capture_step_performance> 53 <step_performance_capturing_delay>1000</step_performance_capturing_delay> 54 <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit> 55 <dependencies> 56 </dependencies> 57 <partitionschemas> 58 </partitionschemas> 59 <slaveservers> 60 </slaveservers> 61 <clusterschemas> 62 </clusterschemas> 63 <created_user>-</created_user> 64 <created_date>2011/07/29 11:22:48.970</created_date> 65 <modified_user>-</modified_user> 66 <modified_date>2011/07/29 11:22:48.970</modified_date> 67 </info> 68 <notepads> 69 </notepads> 70 <connection> 71 <name>ALA_DA_9</name> 72 <server>127.0.0.1</server> 73 <type>POSTGRESQL</type> 74 <access>Native</access> 75 <database>ala_da</database> 76 <port>15432</port> 77 <username>postgres</username> 78 <password>Encrypted 2be98afc86ad7c297bf1ebc75cdad9cfb</password> 79 <servername/> 80 <data_tablespace/> 81 <index_tablespace/> 82 <attributes> 83 <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute> 84 <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute> 85 <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute> 86 <attribute><code>PORT_NUMBER</code><attribute>15432</attribute></attribute> 87 <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute> 88 <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute> 89 <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute> 90 </attributes> 91 </connection> 92 <order> 93 <hop> <from>Table input</from><to>Sort licence_link</to><enabled>Y</enabled> </hop> <hop> <from>Table input</from><to>Sort metadatapath</to><enabled>Y</enabled> </hop> <hop> <from>Table input</from><to>Sort source_link</to><enabled>Y</enabled> </hop> <hop> <from>Filter licence_link</from><to>drop blank licence_link</to><enabled>Y</enabled> </hop> <hop> <from>Sort licence_link</from><to>Filter licence_link</to><enabled>Y</enabled> </hop> <hop> <from>Select id + ll</from><to>Group by licence_link</to><enabled>Y</enabled> </hop> <hop> <from>Filter licence_link</from><to>Select id + ll</to><enabled>Y</enabled> </hop> <hop> <from>Group by licence_link</from><to>XML licence_link</to><enabled>Y</enabled> </hop> <hop> <from>Filter mdp</from><to>drop blank mdp</to><enabled>Y</enabled> </hop> <hop> <from>Filter mdp</from><to>Select id + mdp</to><enabled>Y</enabled> </hop> <hop> <from>Select id + mdp</from><to>Group by mdp</to><enabled>Y</enabled> </hop> <hop> <from>Group by mdp</from><to>XML mdp</to><enabled>Y</enabled> </hop> <hop> <from>Sort metadatapath</from><to>Filter mdp</to><enabled>Y</enabled> </hop> <hop> <from>Filter sl</from><to>drop blank sl</to><enabled>Y</enabled> </hop> <hop> <from>Filter sl</from><to>Select id + sl</to><enabled>Y</enabled> </hop> <hop> <from>Select id + sl</from><to>Group by sl</to><enabled>Y</enabled> </hop> <hop> <from>Group by sl</from><to>XML sl</to><enabled>Y</enabled> </hop> <hop> <from>Sort source_link</from><to>Filter sl</to><enabled>Y</enabled> </hop> </order> 94 <step> 95 <name>Table input</name> 96 <type>TableInput</type> 97 <description/> 98 <distribute>N</distribute> 99 <copies>1</copies> 100 <partitioning> 101 <method>none</method> 102 <schema_name/> 103 </partitioning> 104 <connection>ALA_DA_9</connection> 105 <sql>SELECT 106 id 107, "name" 108, description 109, "type" 110, "source" 111, "path" 112, extents 113, minlatitude 114, minlongitude 115, maxlatitude 116, maxlongitude 117, notes 118, enabled 119, displayname 120, displaypath 121, "scale" 122, environmentalvaluemin 123, environmentalvaluemax 124, environmentalvalueunits 125, lookuptablepath 126, metadatapath 127, classification1 128, classification2 129, uid 130, mddatest 131, citation_date 132, datalang 133, mdhrlv 134, respparty_role 135, licence_level 136, licence_link 137, licence_notes 138, source_link 139FROM "public".vwsp_layers_live 140</sql> 141 <limit>0</limit> 142 <lookup/> 143 <execute_each_row>N</execute_each_row> 144 <variables_active>N</variables_active> 145 <lazy_conversion_active>N</lazy_conversion_active> 146 <cluster_schema/> 147 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 148 <xloc>41</xloc> 149 <yloc>130</yloc> 150 <draw>Y</draw> 151 </GUI> 152 </step> 153 154 <step> 155 <name>Sort licence_link</name> 156 <type>SortRows</type> 157 <description/> 158 <distribute>N</distribute> 159 <copies>1</copies> 160 <partitioning> 161 <method>none</method> 162 <schema_name/> 163 </partitioning> 164 <directory>%%java.io.tmpdir%%</directory> 165 <prefix>out</prefix> 166 <sort_size>1000000</sort_size> 167 <free_memory/> 168 <compress>N</compress> 169 <compress_variable/> 170 <unique_rows>N</unique_rows> 171 <fields> 172 <field> 173 <name>licence_link</name> 174 <ascending>Y</ascending> 175 <case_sensitive>N</case_sensitive> 176 </field> 177 <field> 178 <name>id</name> 179 <ascending>N</ascending> 180 <case_sensitive>N</case_sensitive> 181 </field> 182 </fields> 183 <cluster_schema/> 184 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 185 <xloc>201</xloc> 186 <yloc>50</yloc> 187 <draw>Y</draw> 188 </GUI> 189 </step> 190 191 <step> 192 <name>Sort metadatapath</name> 193 <type>SortRows</type> 194 <description/> 195 <distribute>Y</distribute> 196 <copies>1</copies> 197 <partitioning> 198 <method>none</method> 199 <schema_name/> 200 </partitioning> 201 <directory>%%java.io.tmpdir%%</directory> 202 <prefix>out</prefix> 203 <sort_size>1000000</sort_size> 204 <free_memory/> 205 <compress>N</compress> 206 <compress_variable/> 207 <unique_rows>N</unique_rows> 208 <fields> 209 <field> 210 <name>metadatapath</name> 211 <ascending>Y</ascending> 212 <case_sensitive>N</case_sensitive> 213 </field> 214 <field> 215 <name>id</name> 216 <ascending>N</ascending> 217 <case_sensitive>N</case_sensitive> 218 </field> 219 </fields> 220 <cluster_schema/> 221 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 222 <xloc>201</xloc> 223 <yloc>164</yloc> 224 <draw>Y</draw> 225 </GUI> 226 </step> 227 228 <step> 229 <name>Sort source_link</name> 230 <type>SortRows</type> 231 <description/> 232 <distribute>Y</distribute> 233 <copies>1</copies> 234 <partitioning> 235 <method>none</method> 236 <schema_name/> 237 </partitioning> 238 <directory>%%java.io.tmpdir%%</directory> 239 <prefix>out</prefix> 240 <sort_size>1000000</sort_size> 241 <free_memory/> 242 <compress>N</compress> 243 <compress_variable/> 244 <unique_rows>N</unique_rows> 245 <fields> 246 <field> 247 <name>source_link</name> 248 <ascending>Y</ascending> 249 <case_sensitive>N</case_sensitive> 250 </field> 251 <field> 252 <name>id</name> 253 <ascending>N</ascending> 254 <case_sensitive>N</case_sensitive> 255 </field> 256 </fields> 257 <cluster_schema/> 258 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 259 <xloc>190</xloc> 260 <yloc>265</yloc> 261 <draw>Y</draw> 262 </GUI> 263 </step> 264 265 <step> 266 <name>XML licence_link</name> 267 <type>XMLOutput</type> 268 <description/> 269 <distribute>Y</distribute> 270 <copies>1</copies> 271 <partitioning> 272 <method>none</method> 273 <schema_name/> 274 </partitioning> 275 <encoding>UTF-8</encoding> 276 <name_space/> 277 <xml_main_element>Rows</xml_main_element> 278 <xml_repeat_element>Row</xml_repeat_element> 279 <file> 280 <name>C:\Bryn\ala\spatial portal\layer_index_links_licence</name> 281 <extention>xml</extention> 282 <do_not_open_newfile_init>N</do_not_open_newfile_init> 283 <split>N</split> 284 <add_date>N</add_date> 285 <add_time>N</add_time> 286 <SpecifyFormat>Y</SpecifyFormat> 287 <omit_null_values>N</omit_null_values> 288 <date_time_format>.yyyyMMdd</date_time_format> 289 <add_to_result_filenames>N</add_to_result_filenames> 290 <zipped>N</zipped> 291 <splitevery>0</splitevery> 292 </file> 293 <fields> 294 <field> 295 <name>licence_link</name> 296 <element/> 297 <type>String</type> 298 <format/> 299 <currency/> 300 <decimal/> 301 <group/> 302 <nullif/> 303 <length>-1</length> 304 <precision>-1</precision> 305 </field> 306 <field> 307 <name>ids</name> 308 <element/> 309 <type>String</type> 310 <format/> 311 <currency/> 312 <decimal/> 313 <group/> 314 <nullif/> 315 <length>-1</length> 316 <precision>-1</precision> 317 </field> 318 </fields> 319 <cluster_schema/> 320 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 321 <xloc>701</xloc> 322 <yloc>70</yloc> 323 <draw>Y</draw> 324 </GUI> 325 </step> 326 327 <step> 328 <name>Filter licence_link</name> 329 <type>FilterRows</type> 330 <description/> 331 <distribute>Y</distribute> 332 <copies>1</copies> 333 <partitioning> 334 <method>none</method> 335 <schema_name/> 336 </partitioning> 337<send_true_to>Select id + ll</send_true_to> 338<send_false_to>drop blank licence_link</send_false_to> 339 <compare> 340<condition> 341 <negated>N</negated> 342 <leftvalue>licence_link</leftvalue> 343 <function><></function> 344 <rightvalue/> 345 <value><name>constant</name><type>String</type><text/><length>-1</length><precision>-1</precision><isnull>Y</isnull><mask/></value> </condition> 346 </compare> 347 <cluster_schema/> 348 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 349 <xloc>321</xloc> 350 <yloc>50</yloc> 351 <draw>Y</draw> 352 </GUI> 353 </step> 354 355 <step> 356 <name>drop blank licence_link</name> 357 <type>Dummy</type> 358 <description/> 359 <distribute>Y</distribute> 360 <copies>1</copies> 361 <partitioning> 362 <method>none</method> 363 <schema_name/> 364 </partitioning> 365 <cluster_schema/> 366 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 367 <xloc>512</xloc> 368 <yloc>18</yloc> 369 <draw>Y</draw> 370 </GUI> 371 </step> 372 373 <step> 374 <name>Select id + ll</name> 375 <type>SelectValues</type> 376 <description/> 377 <distribute>N</distribute> 378 <copies>1</copies> 379 <partitioning> 380 <method>none</method> 381 <schema_name/> 382 </partitioning> 383 <fields> <field> <name>id</name> 384 <rename/> 385 <length>-2</length> 386 <precision>-2</precision> 387 </field> <field> <name>licence_link</name> 388 <rename/> 389 <length>-2</length> 390 <precision>-2</precision> 391 </field> <select_unspecified>N</select_unspecified> 392 </fields> <cluster_schema/> 393 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 394 <xloc>441</xloc> 395 <yloc>70</yloc> 396 <draw>Y</draw> 397 </GUI> 398 </step> 399 400 <step> 401 <name>Group by licence_link</name> 402 <type>GroupBy</type> 403 <description/> 404 <distribute>Y</distribute> 405 <copies>1</copies> 406 <partitioning> 407 <method>none</method> 408 <schema_name/> 409 </partitioning> 410 <all_rows>N</all_rows> 411 <ignore_aggregate>N</ignore_aggregate> 412 <field_ignore/> 413 <directory>%%java.io.tmpdir%%</directory> 414 <prefix>grp</prefix> 415 <add_linenr>N</add_linenr> 416 <linenr_fieldname/> 417 <give_back_row>N</give_back_row> 418 <group> 419 <field> 420 <name>licence_link</name> 421 </field> 422 </group> 423 <fields> 424 <field> 425 <aggregate>ids</aggregate> 426 <subject>id</subject> 427 <type>CONCAT_STRING</type> 428 <valuefield>,</valuefield> 429 </field> 430 </fields> 431 <cluster_schema/> 432 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 433 <xloc>561</xloc> 434 <yloc>70</yloc> 435 <draw>Y</draw> 436 </GUI> 437 </step> 438 439 <step> 440 <name>XML mdp</name> 441 <type>XMLOutput</type> 442 <description/> 443 <distribute>Y</distribute> 444 <copies>1</copies> 445 <partitioning> 446 <method>none</method> 447 <schema_name/> 448 </partitioning> 449 <encoding>UTF-8</encoding> 450 <name_space/> 451 <xml_main_element>Rows</xml_main_element> 452 <xml_repeat_element>Row</xml_repeat_element> 453 <file> 454 <name>C:\Bryn\ala\spatial portal\layer_index_links_mdpath</name> 455 <extention>xml</extention> 456 <do_not_open_newfile_init>N</do_not_open_newfile_init> 457 <split>N</split> 458 <add_date>N</add_date> 459 <add_time>N</add_time> 460 <SpecifyFormat>Y</SpecifyFormat> 461 <omit_null_values>N</omit_null_values> 462 <date_time_format>.yyyyMMdd</date_time_format> 463 <add_to_result_filenames>N</add_to_result_filenames> 464 <zipped>N</zipped> 465 <splitevery>0</splitevery> 466 </file> 467 <fields> 468 <field> 469 <name>metadatapath</name> 470 <element/> 471 <type>String</type> 472 <format/> 473 <currency/> 474 <decimal/> 475 <group/> 476 <nullif/> 477 <length>-1</length> 478 <precision>-1</precision> 479 </field> 480 <field> 481 <name>ids</name> 482 <element/> 483 <type>String</type> 484 <format/> 485 <currency/> 486 <decimal/> 487 <group/> 488 <nullif/> 489 <length>-1</length> 490 <precision>-1</precision> 491 </field> 492 </fields> 493 <cluster_schema/> 494 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 495 <xloc>703</xloc> 496 <yloc>190</yloc> 497 <draw>Y</draw> 498 </GUI> 499 </step> 500 501 <step> 502 <name>Filter mdp</name> 503 <type>FilterRows</type> 504 <description/> 505 <distribute>Y</distribute> 506 <copies>1</copies> 507 <partitioning> 508 <method>none</method> 509 <schema_name/> 510 </partitioning> 511<send_true_to>Select id + mdp</send_true_to> 512<send_false_to>drop blank mdp</send_false_to> 513 <compare> 514<condition> 515 <negated>N</negated> 516 <leftvalue>metadatapath</leftvalue> 517 <function><></function> 518 <rightvalue/> 519 <value><name>constant</name><type>String</type><text/><length>-1</length><precision>-1</precision><isnull>Y</isnull><mask/></value> </condition> 520 </compare> 521 <cluster_schema/> 522 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 523 <xloc>323</xloc> 524 <yloc>170</yloc> 525 <draw>Y</draw> 526 </GUI> 527 </step> 528 529 <step> 530 <name>drop blank mdp</name> 531 <type>Dummy</type> 532 <description/> 533 <distribute>Y</distribute> 534 <copies>1</copies> 535 <partitioning> 536 <method>none</method> 537 <schema_name/> 538 </partitioning> 539 <cluster_schema/> 540 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 541 <xloc>509</xloc> 542 <yloc>145</yloc> 543 <draw>Y</draw> 544 </GUI> 545 </step> 546 547 <step> 548 <name>Select id + mdp</name> 549 <type>SelectValues</type> 550 <description/> 551 <distribute>N</distribute> 552 <copies>1</copies> 553 <partitioning> 554 <method>none</method> 555 <schema_name/> 556 </partitioning> 557 <fields> <field> <name>id</name> 558 <rename/> 559 <length>-2</length> 560 <precision>-2</precision> 561 </field> <field> <name>metadatapath</name> 562 <rename/> 563 <length>-2</length> 564 <precision>-2</precision> 565 </field> <select_unspecified>N</select_unspecified> 566 </fields> <cluster_schema/> 567 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 568 <xloc>443</xloc> 569 <yloc>190</yloc> 570 <draw>Y</draw> 571 </GUI> 572 </step> 573 574 <step> 575 <name>Group by mdp</name> 576 <type>GroupBy</type> 577 <description/> 578 <distribute>Y</distribute> 579 <copies>1</copies> 580 <partitioning> 581 <method>none</method> 582 <schema_name/> 583 </partitioning> 584 <all_rows>N</all_rows> 585 <ignore_aggregate>N</ignore_aggregate> 586 <field_ignore/> 587 <directory>%%java.io.tmpdir%%</directory> 588 <prefix>grp</prefix> 589 <add_linenr>N</add_linenr> 590 <linenr_fieldname/> 591 <give_back_row>N</give_back_row> 592 <group> 593 <field> 594 <name>metadatapath</name> 595 </field> 596 </group> 597 <fields> 598 <field> 599 <aggregate>ids</aggregate> 600 <subject>id</subject> 601 <type>CONCAT_STRING</type> 602 <valuefield>,</valuefield> 603 </field> 604 </fields> 605 <cluster_schema/> 606 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 607 <xloc>581</xloc> 608 <yloc>190</yloc> 609 <draw>Y</draw> 610 </GUI> 611 </step> 612 613 <step> 614 <name>XML sl</name> 615 <type>XMLOutput</type> 616 <description/> 617 <distribute>Y</distribute> 618 <copies>1</copies> 619 <partitioning> 620 <method>none</method> 621 <schema_name/> 622 </partitioning> 623 <encoding>UTF-8</encoding> 624 <name_space/> 625 <xml_main_element>Rows</xml_main_element> 626 <xml_repeat_element>Row</xml_repeat_element> 627 <file> 628 <name>C:\Bryn\ala\spatial portal\layer_index_links_source</name> 629 <extention>xml</extention> 630 <do_not_open_newfile_init>N</do_not_open_newfile_init> 631 <split>N</split> 632 <add_date>N</add_date> 633 <add_time>N</add_time> 634 <SpecifyFormat>Y</SpecifyFormat> 635 <omit_null_values>N</omit_null_values> 636 <date_time_format>.yyyyMMdd</date_time_format> 637 <add_to_result_filenames>N</add_to_result_filenames> 638 <zipped>N</zipped> 639 <splitevery>0</splitevery> 640 </file> 641 <fields> 642 <field> 643 <name>source_link</name> 644 <element/> 645 <type>String</type> 646 <format/> 647 <currency/> 648 <decimal/> 649 <group/> 650 <nullif/> 651 <length>-1</length> 652 <precision>-1</precision> 653 </field> 654 <field> 655 <name>ids</name> 656 <element/> 657 <type>String</type> 658 <format/> 659 <currency/> 660 <decimal/> 661 <group/> 662 <nullif/> 663 <length>-1</length> 664 <precision>-1</precision> 665 </field> 666 </fields> 667 <cluster_schema/> 668 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 669 <xloc>714</xloc> 670 <yloc>312</yloc> 671 <draw>Y</draw> 672 </GUI> 673 </step> 674 675 <step> 676 <name>Filter sl</name> 677 <type>FilterRows</type> 678 <description/> 679 <distribute>Y</distribute> 680 <copies>1</copies> 681 <partitioning> 682 <method>none</method> 683 <schema_name/> 684 </partitioning> 685<send_true_to>Select id + sl</send_true_to> 686<send_false_to>drop blank sl</send_false_to> 687 <compare> 688<condition> 689 <negated>N</negated> 690 <leftvalue>source_link</leftvalue> 691 <function><></function> 692 <rightvalue/> 693 <value><name>constant</name><type>String</type><text/><length>-1</length><precision>-1</precision><isnull>Y</isnull><mask/></value> </condition> 694 </compare> 695 <cluster_schema/> 696 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 697 <xloc>334</xloc> 698 <yloc>292</yloc> 699 <draw>Y</draw> 700 </GUI> 701 </step> 702 703 <step> 704 <name>drop blank sl</name> 705 <type>Dummy</type> 706 <description/> 707 <distribute>Y</distribute> 708 <copies>1</copies> 709 <partitioning> 710 <method>none</method> 711 <schema_name/> 712 </partitioning> 713 <cluster_schema/> 714 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 715 <xloc>516</xloc> 716 <yloc>264</yloc> 717 <draw>Y</draw> 718 </GUI> 719 </step> 720 721 <step> 722 <name>Select id + sl</name> 723 <type>SelectValues</type> 724 <description/> 725 <distribute>N</distribute> 726 <copies>1</copies> 727 <partitioning> 728 <method>none</method> 729 <schema_name/> 730 </partitioning> 731 <fields> <field> <name>id</name> 732 <rename/> 733 <length>-2</length> 734 <precision>-2</precision> 735 </field> <field> <name>source_link</name> 736 <rename/> 737 <length>-2</length> 738 <precision>-2</precision> 739 </field> <select_unspecified>N</select_unspecified> 740 </fields> <cluster_schema/> 741 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 742 <xloc>454</xloc> 743 <yloc>312</yloc> 744 <draw>Y</draw> 745 </GUI> 746 </step> 747 748 <step> 749 <name>Group by sl</name> 750 <type>GroupBy</type> 751 <description/> 752 <distribute>Y</distribute> 753 <copies>1</copies> 754 <partitioning> 755 <method>none</method> 756 <schema_name/> 757 </partitioning> 758 <all_rows>N</all_rows> 759 <ignore_aggregate>N</ignore_aggregate> 760 <field_ignore/> 761 <directory>%%java.io.tmpdir%%</directory> 762 <prefix>grp</prefix> 763 <add_linenr>N</add_linenr> 764 <linenr_fieldname/> 765 <give_back_row>N</give_back_row> 766 <group> 767 <field> 768 <name>source_link</name> 769 </field> 770 </group> 771 <fields> 772 <field> 773 <aggregate>ids</aggregate> 774 <subject>id</subject> 775 <type>CONCAT_STRING</type> 776 <valuefield>,</valuefield> 777 </field> 778 </fields> 779 <cluster_schema/> 780 <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> 781 <xloc>586</xloc> 782 <yloc>312</yloc> 783 <draw>Y</draw> 784 </GUI> 785 </step> 786 787 <step_error_handling> 788 </step_error_handling> 789 <slave-step-copy-partition-distribution> 790</slave-step-copy-partition-distribution> 791 <slave_transformation>N</slave_transformation> 792</transformation>