PageRenderTime 44ms CodeModel.GetById 12ms app.highlight 14ms RepoModel.GetById 2ms app.codeStats 0ms

/database/metadata_dev/layer_index_link_analysis.ktr

http://alageospatialportal.googlecode.com/
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>&#47;</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&#47;07&#47;29 11:22:48.970</created_date>
 65  <modified_user>-</modified_user>
 66  <modified_date>2011&#47;07&#47;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, &quot;name&quot;
108, description
109, &quot;type&quot;
110, &quot;source&quot;
111, &quot;path&quot;
112, extents
113, minlatitude
114, minlongitude
115, maxlatitude
116, maxlongitude
117, notes
118, enabled
119, displayname
120, displaypath
121, &quot;scale&quot;
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 &quot;public&quot;.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>&lt;&gt;</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>&lt;&gt;</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>&lt;&gt;</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>