Subversion Repositories SmartDukaan

Rev

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

Rev 3510 Rev 5156
Line 140... Line 140...
140 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
 140 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
141 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
 141 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
142 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
 142 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
143 
    </attributes>
 143 
    </attributes>
144 
  </connection>
 144 
  </connection>
- 
 
 145 
  <connection>
- 
 
 146 
    <name>salesLocal</name>
- 
 
 147 
    <server>localhost</server>
- 
 
 148 
    <type>MYSQL</type>
- 
 
 149 
    <access>Native</access>
- 
 
 150 
    <database>sales</database>
- 
 
 151 
    <port>3306</port>
- 
 
 152 
    <username>root</username>
- 
 
 153 
    <password>Encrypted 2be98afc86aa7f2e4b811a1608cc2fd8a</password>
- 
 
 154 
    <servername/>
- 
 
 155 
    <data_tablespace/>
- 
 
 156 
    <index_tablespace/>
- 
 
 157 
    <attributes>
- 
 
 158 
      <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
- 
 
 159 
      <attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute>
- 
 
 160 
      <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
- 
 
 161 
      <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
- 
 
 162 
      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
- 
 
 163 
      <attribute><code>PORT_NUMBER</code><attribute>3306</attribute></attribute>
- 
 
 164 
      <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
- 
 
 165 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
- 
 
 166 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
- 
 
 167 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
- 
 
 168 
    </attributes>
- 
 
 169 
  </connection>
145 
  <order>
 170 
  <order>
146 
  <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>
 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>
147 
  <step>
 172 
  <step>
148 
    <name>items</name>
 173 
    <name>items</name>
149 
    <type>TableInput</type>
 174 
    <type>TableInput</type>
Line 154... Line 179...
154 
           <method>none</method>
 179 
           <method>none</method>
155 
           <schema_name/>
 180 
           <schema_name/>
156 
           </partitioning>
 181 
           </partitioning>
157 
    <connection>catalogDC_Prod</connection>
 182 
    <connection>catalogDC_Prod</connection>
158 
    <sql>SELECT SQL_NO_CACHE item.id, item.catalog_item_id, product_group, brand, model_number, model_name,
183 
    <sql>SELECT SQL_NO_CACHE item.id, item.catalog_item_id, product_group, brand, model_number, model_name,
159 
       color, category.label category, parent.label parent_category
 184 
       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
160 
FROM item, category, category as parent
186 
FROM item, category, category as parent
161 
where item.category = category.id
187 
where item.category = category.id
162 
and category.parent_category_id = parent.id</sql>
 188 
and category.parent_category_id = parent.id</sql>
163 
    <limit>0</limit>
 189 
    <limit>0</limit>
164 
    <lookup/>
 190 
    <lookup/>
Line 227... Line 253...
227 
        </field>
 253 
        </field>
228 
        <field>
 254 
        <field>
229 
          <column_name>category</column_name>
 255 
          <column_name>category</column_name>
230 
          <stream_name>category</stream_name>
 256 
          <stream_name>category</stream_name>
231 
        </field>
 257 
        </field>
- 
 
 258 
        <field>
- 
 
 259 
          <column_name>catalog_item_id</column_name>
- 
 
 260 
          <stream_name>catalog_item_id</stream_name>
- 
 
 261 
        </field>
- 
 
 262 
        <field>
- 
 
 263 
          <column_name>parent_category</column_name>
- 
 
 264 
          <stream_name>parent_category</stream_name>
- 
 
 265 
        </field>
- 
 
 266 
        <field>
- 
 
 267 
          <column_name>price_range</column_name>
- 
 
 268 
          <stream_name>price_range</stream_name>
- 
 
 269 
        </field>
232 
    </fields>
 270 
    </fields>
233 
     <cluster_schema/>
 271 
     <cluster_schema/>
234 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 272 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
235 
      <xloc>435</xloc>
 273 
      <xloc>435</xloc>
236 
      <yloc>166</yloc>
 274 
      <yloc>166</yloc>
Line 250... Line 288...
250 
           </partitioning>
 288 
           </partitioning>
251 
    <fields>      <field>        <name>id</name>
 289 
    <fields>      <field>        <name>id</name>
252 
        <rename/>
 290 
        <rename/>
253 
        <length>-2</length>
 291 
        <length>-2</length>
254 
        <precision>-2</precision>
 292 
        <precision>-2</precision>
- 
 
 293 
      </field>      <field>        <name>catalog_item_id</name>
- 
 
 294 
        <rename/>
- 
 
 295 
        <length>-2</length>
- 
 
 296 
        <precision>-2</precision>
255 
      </field>      <field>        <name>product_group</name>
 297 
      </field>      <field>        <name>product_group</name>
256 
        <rename/>
 298 
        <rename/>
257 
        <length>-2</length>
 299 
        <length>-2</length>
258 
        <precision>-2</precision>
 300 
        <precision>-2</precision>
259 
      </field>      <field>        <name>brand</name>
 301 
      </field>      <field>        <name>brand</name>
Line 278... Line 320...
278 
        <precision>-2</precision>
 320 
        <precision>-2</precision>
279 
      </field>      <field>        <name>parent_category</name>
 321 
      </field>      <field>        <name>parent_category</name>
280 
        <rename/>
 322 
        <rename/>
281 
        <length>-2</length>
 323 
        <length>-2</length>
282 
        <precision>-2</precision>
 324 
        <precision>-2</precision>
283 
      </field>      <field>        <name>catalog_item_id</name>
 325 
      </field>      <field>        <name>price_range</name>
284 
        <rename/>
 326 
        <rename/>
285 
        <length>-2</length>
 327 
        <length>-2</length>
286 
        <precision>-2</precision>
 328 
        <precision>-2</precision>
287 
      </field>        <select_unspecified>N</select_unspecified>
 329 
      </field>        <select_unspecified>N</select_unspecified>
288 
    </fields>     <cluster_schema/>
 330 
    </fields>     <cluster_schema/>