Subversion Repositories SmartDukaan

Rev

Rev 5392 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5392 Rev 6554
Line 165... Line 165...
165 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
 165 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
166 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
 166 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
167 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
 167 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
168 
    </attributes>
 168 
    </attributes>
169 
  </connection>
 169 
  </connection>
- 
 
 170 
  <connection>
- 
 
 171 
    <name>transaction_local</name>
- 
 
 172 
    <server>localhost</server>
- 
 
 173 
    <type>MYSQL</type>
- 
 
 174 
    <access>Native</access>
- 
 
 175 
    <database>transaction</database>
- 
 
 176 
    <port>3306</port>
- 
 
 177 
    <username>root</username>
- 
 
 178 
    <password>Encrypted 2be98afc86aa7f2e4b811a1608cc2fd8a</password>
- 
 
 179 
    <servername/>
- 
 
 180 
    <data_tablespace/>
- 
 
 181 
    <index_tablespace/>
- 
 
 182 
    <attributes>
- 
 
 183 
      <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
- 
 
 184 
      <attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute>
- 
 
 185 
      <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
- 
 
 186 
      <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
- 
 
 187 
      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
- 
 
 188 
      <attribute><code>PORT_NUMBER</code><attribute>3306</attribute></attribute>
- 
 
 189 
      <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
- 
 
 190 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
- 
 
 191 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
- 
 
 192 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
- 
 
 193 
    </attributes>
- 
 
 194 
  </connection>
170 
  <order>
 195 
  <order>
171 
  <hop> <from>items</from><to>items_Mapping</to><enabled>Y</enabled> </hop>  <hop> <from>items_Mapping</from><to>items_DW</to><enabled>Y</enabled> </hop>  </order>
 196 
  <hop> <from>items</from><to>items_Mapping</to><enabled>Y</enabled> </hop>  <hop> <from>items_Mapping</from><to>Append streams</to><enabled>Y</enabled> </hop>  <hop> <from>RechargeOperators</from><to>rechargeOperatorSelector</to><enabled>Y</enabled> </hop>  <hop> <from>Append streams</from><to>items_DW</to><enabled>Y</enabled> </hop>  <hop> <from>rechargeOperatorSelector</from><to>Append streams</to><enabled>Y</enabled> </hop>  </order>
172 
  <step>
 197 
  <step>
173 
    <name>items</name>
 198 
    <name>items</name>
174 
    <type>TableInput</type>
 199 
    <type>TableInput</type>
175 
    <description/>
 200 
    <description/>
176 
    <distribute>Y</distribute>
 201 
    <distribute>Y</distribute>
177 
    <copies>1</copies>
 202 
    <copies>1</copies>
178 
         <partitioning>
 203 
         <partitioning>
179 
           <method>none</method>
 204 
           <method>none</method>
180 
           <schema_name/>
 205 
           <schema_name/>
181 
           </partitioning>
 206 
           </partitioning>
182 
    <connection>catalogDC_Prod</connection>
 207 
    <connection>catalogDC_local</connection>
183 
    <sql>SELECT SQL_NO_CACHE item.id, item.catalog_item_id, product_group, brand, model_number, model_name,
208 
    <sql>SELECT SQL_NO_CACHE item.id, item.catalog_item_id, product_group, brand, model_number, model_name,
184 
       color, category.label category, parent.label parent_category,
 209 
       color, category.label category, parent.label parent_category,
185 
case when sellingPrice&lt;2000 then &apos;a) 0-2000&apos; when sellingPrice &lt; 5000 then &apos;b) 2000-5000&apos; when sellingPrice &lt; 10000 then &apos;c) 5000-10000&apos; when sellingPrice &lt; 15000 then &apos;d) 10000-15000&apos; when sellingPrice &lt;20000 then &apos;e) 15000-20000&apos; when sellingPrice &lt; 50000 then &apos;f) 20000-50000&apos; else &apos;g) More than 50000&apos; end as price_range
 210 
case when sellingPrice &lt; 2000 then &apos;a) 0-2000&apos; when sellingPrice &lt; 5000 then &apos;b) 2000-5000&apos; when sellingPrice &lt; 10000 then &apos;c) 5000-10000&apos; when sellingPrice &lt; 15000 then &apos;d) 10000-15000&apos; when sellingPrice &lt;20000 then &apos;e) 15000-20000&apos; when sellingPrice &lt; 50000 then &apos;f) 20000-50000&apos; else &apos;g) More than 50000&apos; end as price_range
186 
FROM item, category, category as parent
211 
FROM item, category, category as parent
187 
where item.category = category.id
212 
where item.category = category.id
188 
and category.parent_category_id = parent.id</sql>
 213 
and category.parent_category_id = parent.id</sql>
189 
    <limit>0</limit>
 214 
    <limit>0</limit>
190 
    <lookup/>
 215 
    <lookup/>
Line 208... Line 233...
208 
         <partitioning>
 233 
         <partitioning>
209 
           <method>none</method>
 234 
           <method>none</method>
210 
           <schema_name/>
 235 
           <schema_name/>
211 
           </partitioning>
 236 
           </partitioning>
212 
    <connection>catalogDC</connection>
 237 
    <connection>catalogDC</connection>
213 
    <schema/>
 238 
    <schema>sales</schema>
214 
    <table>item</table>
 239 
    <table>item</table>
215 
    <commit>1000</commit>
 240 
    <commit>1000</commit>
216 
    <truncate>Y</truncate>
 241 
    <truncate>Y</truncate>
217 
    <ignore_errors>N</ignore_errors>
 242 
    <ignore_errors>N</ignore_errors>
218 
    <use_batch>Y</use_batch>
 243 
    <use_batch>Y</use_batch>
Line 268... Line 293...
268 
          <stream_name>price_range</stream_name>
 293 
          <stream_name>price_range</stream_name>
269 
        </field>
 294 
        </field>
270 
    </fields>
 295 
    </fields>
271 
     <cluster_schema/>
 296 
     <cluster_schema/>
272 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 297 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
273 
      <xloc>435</xloc>
 298 
      <xloc>752</xloc>
274 
      <yloc>166</yloc>
 299 
      <yloc>159</yloc>
275 
      <draw>Y</draw>
 300 
      <draw>Y</draw>
276 
      </GUI>
 301 
      </GUI>
277 
    </step>
 302 
    </step>
278 
 
 303 
 
279 
  <step>
 304 
  <step>
Line 325... Line 350...
325 
      </field>      <field>        <name>price_range</name>
 350 
      </field>      <field>        <name>price_range</name>
326 
        <rename/>
 351 
        <rename/>
327 
        <length>-2</length>
 352 
        <length>-2</length>
328 
        <precision>-2</precision>
 353 
        <precision>-2</precision>
329 
      </field>        <select_unspecified>N</select_unspecified>
 354 
      </field>        <select_unspecified>N</select_unspecified>
- 
 
 355 
      <meta>        <name>id</name>
- 
 
 356 
        <rename>id</rename>
- 
 
 357 
        <type>Integer</type>
- 
 
 358 
        <length>-2</length>
- 
 
 359 
        <precision>-2</precision>
- 
 
 360 
        <conversion_mask/>
- 
 
 361 
        <date_format_lenient>false</date_format_lenient>
- 
 
 362 
        <encoding/>
- 
 
 363 
        <decimal_symbol/>
- 
 
 364 
        <grouping_symbol/>
- 
 
 365 
        <currency_symbol/>
- 
 
 366 
        <storage_type/>
330 
    </fields>     <cluster_schema/>
 367 
      </meta>    </fields>     <cluster_schema/>
- 
 
 368 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
- 
 
 369 
      <xloc>256</xloc>
- 
 
 370 
      <yloc>163</yloc>
- 
 
 371 
      <draw>Y</draw>
- 
 
 372 
      </GUI>
- 
 
 373 
    </step>
- 
 
 374 
 
- 
 
 375 
  <step>
- 
 
 376 
    <name>RechargeOperators</name>
- 
 
 377 
    <type>TableInput</type>
- 
 
 378 
    <description/>
- 
 
 379 
    <distribute>Y</distribute>
- 
 
 380 
    <copies>1</copies>
- 
 
 381 
         <partitioning>
- 
 
 382 
           <method>none</method>
- 
 
 383 
           <schema_name/>
- 
 
 384 
           </partitioning>
- 
 
 385 
    <connection>transaction_local</connection>
- 
 
 386 
    <sql>SELECT SQL_NO_CACHE 100000+id as id, 0 as catalog_item_id, &apos;Recharge&apos; as product_group, name as brand, case when type = 2 then &apos;DTH&apos; when type = 1 then &apos;Mobile&apos; end as model_number, &apos;&apos; as model_name,
- 
 
 387 
       &apos;N&#47;A&apos; as color, &apos;Recharge&apos; as category, &apos;Digital&apos; as parent_category,
- 
 
 388 
&apos;N&#47;A&apos; as price_range
- 
 
 389 
FROM serviceprovider </sql>
- 
 
 390 
    <limit>0</limit>
- 
 
 391 
    <lookup/>
- 
 
 392 
    <execute_each_row>N</execute_each_row>
- 
 
 393 
    <variables_active>N</variables_active>
- 
 
 394 
    <lazy_conversion_active>N</lazy_conversion_active>
- 
 
 395 
     <cluster_schema/>
- 
 
 396 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
- 
 
 397 
      <xloc>143</xloc>
- 
 
 398 
      <yloc>322</yloc>
- 
 
 399 
      <draw>Y</draw>
- 
 
 400 
      </GUI>
- 
 
 401 
    </step>
- 
 
 402 
 
- 
 
 403 
  <step>
- 
 
 404 
    <name>Append streams</name>
- 
 
 405 
    <type>Append</type>
- 
 
 406 
    <description/>
- 
 
 407 
    <distribute>Y</distribute>
- 
 
 408 
    <copies>1</copies>
- 
 
 409 
         <partitioning>
- 
 
 410 
           <method>none</method>
- 
 
 411 
           <schema_name/>
- 
 
 412 
           </partitioning>
- 
 
 413 
<head_name>items_Mapping</head_name>
- 
 
 414 
<tail_name>rechargeOperatorSelector</tail_name>
- 
 
 415 
     <cluster_schema/>
- 
 
 416 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
- 
 
 417 
      <xloc>461</xloc>
- 
 
 418 
      <yloc>231</yloc>
- 
 
 419 
      <draw>Y</draw>
- 
 
 420 
      </GUI>
- 
 
 421 
    </step>
- 
 
 422 
 
- 
 
 423 
  <step>
- 
 
 424 
    <name>rechargeOperatorSelector</name>
- 
 
 425 
    <type>SelectValues</type>
- 
 
 426 
    <description/>
- 
 
 427 
    <distribute>Y</distribute>
- 
 
 428 
    <copies>1</copies>
- 
 
 429 
         <partitioning>
- 
 
 430 
           <method>none</method>
- 
 
 431 
           <schema_name/>
- 
 
 432 
           </partitioning>
- 
 
 433 
    <fields>      <field>        <name>id</name>
- 
 
 434 
        <rename/>
- 
 
 435 
        <length>-2</length>
- 
 
 436 
        <precision>-2</precision>
- 
 
 437 
      </field>      <field>        <name>catalog_item_id</name>
- 
 
 438 
        <rename/>
- 
 
 439 
        <length>-2</length>
- 
 
 440 
        <precision>-2</precision>
- 
 
 441 
      </field>      <field>        <name>product_group</name>
- 
 
 442 
        <rename/>
- 
 
 443 
        <length>-2</length>
- 
 
 444 
        <precision>-2</precision>
- 
 
 445 
      </field>      <field>        <name>brand</name>
- 
 
 446 
        <rename/>
- 
 
 447 
        <length>-2</length>
- 
 
 448 
        <precision>-2</precision>
- 
 
 449 
      </field>      <field>        <name>model_number</name>
- 
 
 450 
        <rename/>
- 
 
 451 
        <length>-2</length>
- 
 
 452 
        <precision>-2</precision>
- 
 
 453 
      </field>      <field>        <name>model_name</name>
- 
 
 454 
        <rename/>
- 
 
 455 
        <length>-2</length>
- 
 
 456 
        <precision>-2</precision>
- 
 
 457 
      </field>      <field>        <name>color</name>
- 
 
 458 
        <rename/>
- 
 
 459 
        <length>-2</length>
- 
 
 460 
        <precision>-2</precision>
- 
 
 461 
      </field>      <field>        <name>category</name>
- 
 
 462 
        <rename/>
- 
 
 463 
        <length>-2</length>
- 
 
 464 
        <precision>-2</precision>
- 
 
 465 
      </field>      <field>        <name>parent_category</name>
- 
 
 466 
        <rename/>
- 
 
 467 
        <length>-2</length>
- 
 
 468 
        <precision>-2</precision>
- 
 
 469 
      </field>      <field>        <name>price_range</name>
- 
 
 470 
        <rename/>
- 
 
 471 
        <length>-2</length>
- 
 
 472 
        <precision>-2</precision>
- 
 
 473 
      </field>        <select_unspecified>N</select_unspecified>
- 
 
 474 
      <meta>        <name>id</name>
- 
 
 475 
        <rename>id</rename>
- 
 
 476 
        <type>Integer</type>
- 
 
 477 
        <length>11</length>
- 
 
 478 
        <precision>0</precision>
- 
 
 479 
        <conversion_mask/>
- 
 
 480 
        <date_format_lenient>false</date_format_lenient>
- 
 
 481 
        <encoding/>
- 
 
 482 
        <decimal_symbol/>
- 
 
 483 
        <grouping_symbol/>
- 
 
 484 
        <currency_symbol/>
- 
 
 485 
        <storage_type/>
- 
 
 486 
      </meta>      <meta>        <name>catalog_item_id</name>
- 
 
 487 
        <rename>catalog_item_id</rename>
- 
 
 488 
        <type>Integer</type>
- 
 
 489 
        <length>9</length>
- 
 
 490 
        <precision>0</precision>
- 
 
 491 
        <conversion_mask/>
- 
 
 492 
        <date_format_lenient>false</date_format_lenient>
- 
 
 493 
        <encoding/>
- 
 
 494 
        <decimal_symbol/>
- 
 
 495 
        <grouping_symbol/>
- 
 
 496 
        <currency_symbol/>
- 
 
 497 
        <storage_type/>
- 
 
 498 
      </meta>      <meta>        <name>product_group</name>
- 
 
 499 
        <rename>product_group</rename>
- 
 
 500 
        <type>-</type>
- 
 
 501 
        <length>8</length>
- 
 
 502 
        <precision>-2</precision>
- 
 
 503 
        <conversion_mask/>
- 
 
 504 
        <date_format_lenient>false</date_format_lenient>
- 
 
 505 
        <encoding/>
- 
 
 506 
        <decimal_symbol/>
- 
 
 507 
        <grouping_symbol/>
- 
 
 508 
        <currency_symbol/>
- 
 
 509 
        <storage_type/>
- 
 
 510 
      </meta>      <meta>        <name>brand</name>
- 
 
 511 
        <rename>brand</rename>
- 
 
 512 
        <type>-</type>
- 
 
 513 
        <length>50</length>
- 
 
 514 
        <precision>-2</precision>
- 
 
 515 
        <conversion_mask/>
- 
 
 516 
        <date_format_lenient>false</date_format_lenient>
- 
 
 517 
        <encoding/>
- 
 
 518 
        <decimal_symbol/>
- 
 
 519 
        <grouping_symbol/>
- 
 
 520 
        <currency_symbol/>
- 
 
 521 
        <storage_type/>
- 
 
 522 
      </meta>      <meta>        <name>model_number</name>
- 
 
 523 
        <rename>model_number</rename>
- 
 
 524 
        <type>-</type>
- 
 
 525 
        <length>6</length>
- 
 
 526 
        <precision>-2</precision>
- 
 
 527 
        <conversion_mask/>
- 
 
 528 
        <date_format_lenient>false</date_format_lenient>
- 
 
 529 
        <encoding/>
- 
 
 530 
        <decimal_symbol/>
- 
 
 531 
        <grouping_symbol/>
- 
 
 532 
        <currency_symbol/>
- 
 
 533 
        <storage_type/>
- 
 
 534 
      </meta>      <meta>        <name>model_name</name>
- 
 
 535 
        <rename>model_name</rename>
- 
 
 536 
        <type>-</type>
- 
 
 537 
        <length>0</length>
- 
 
 538 
        <precision>-2</precision>
- 
 
 539 
        <conversion_mask/>
- 
 
 540 
        <date_format_lenient>false</date_format_lenient>
- 
 
 541 
        <encoding/>
- 
 
 542 
        <decimal_symbol/>
- 
 
 543 
        <grouping_symbol/>
- 
 
 544 
        <currency_symbol/>
- 
 
 545 
        <storage_type/>
- 
 
 546 
      </meta>      <meta>        <name>color</name>
- 
 
 547 
        <rename>color</rename>
- 
 
 548 
        <type>-</type>
- 
 
 549 
        <length>3</length>
- 
 
 550 
        <precision>-2</precision>
- 
 
 551 
        <conversion_mask/>
- 
 
 552 
        <date_format_lenient>false</date_format_lenient>
- 
 
 553 
        <encoding/>
- 
 
 554 
        <decimal_symbol/>
- 
 
 555 
        <grouping_symbol/>
- 
 
 556 
        <currency_symbol/>
- 
 
 557 
        <storage_type/>
- 
 
 558 
      </meta>      <meta>        <name>category</name>
- 
 
 559 
        <rename>category</rename>
- 
 
 560 
        <type>-</type>
- 
 
 561 
        <length>8</length>
- 
 
 562 
        <precision>-2</precision>
- 
 
 563 
        <conversion_mask/>
- 
 
 564 
        <date_format_lenient>false</date_format_lenient>
- 
 
 565 
        <encoding/>
- 
 
 566 
        <decimal_symbol/>
- 
 
 567 
        <grouping_symbol/>
- 
 
 568 
        <currency_symbol/>
- 
 
 569 
        <storage_type/>
- 
 
 570 
      </meta>      <meta>        <name>parent_category</name>
- 
 
 571 
        <rename>parent_category</rename>
- 
 
 572 
        <type>-</type>
- 
 
 573 
        <length>7</length>
- 
 
 574 
        <precision>-2</precision>
- 
 
 575 
        <conversion_mask/>
- 
 
 576 
        <date_format_lenient>false</date_format_lenient>
- 
 
 577 
        <encoding/>
- 
 
 578 
        <decimal_symbol/>
- 
 
 579 
        <grouping_symbol/>
- 
 
 580 
        <currency_symbol/>
- 
 
 581 
        <storage_type/>
- 
 
 582 
      </meta>      <meta>        <name>price_range</name>
- 
 
 583 
        <rename>price_range</rename>
- 
 
 584 
        <type>-</type>
- 
 
 585 
        <length>15</length>
- 
 
 586 
        <precision>0</precision>
- 
 
 587 
        <conversion_mask/>
- 
 
 588 
        <date_format_lenient>false</date_format_lenient>
- 
 
 589 
        <encoding/>
- 
 
 590 
        <decimal_symbol/>
- 
 
 591 
        <grouping_symbol/>
- 
 
 592 
        <currency_symbol/>
- 
 
 593 
        <storage_type/>
- 
 
 594 
      </meta>    </fields>     <cluster_schema/>
331 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 595 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
332 
      <xloc>304</xloc>
 596 
      <xloc>325</xloc>
333 
      <yloc>167</yloc>
 597 
      <yloc>322</yloc>
334 
      <draw>Y</draw>
 598 
      <draw>Y</draw>
335 
      </GUI>
 599 
      </GUI>
336 
    </step>
 600 
    </step>
337 
 
 601 
 
338 
  <step_error_handling>
 602 
  <step_error_handling>