| Line 190... |
Line 190... |
| 190 |
<attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
|
190 |
<attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
|
| 191 |
<attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
|
191 |
<attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
|
| 192 |
<attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
|
192 |
<attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
|
| 193 |
</attributes>
|
193 |
</attributes>
|
| 194 |
</connection>
|
194 |
</connection>
|
| - |
|
195 |
<connection>
|
| - |
|
196 |
<name>transProd</name>
|
| - |
|
197 |
<server>192.168.190.113</server>
|
| - |
|
198 |
<type>MYSQL</type>
|
| - |
|
199 |
<access>Native</access>
|
| - |
|
200 |
<database>transaction</database>
|
| - |
|
201 |
<port>3306</port>
|
| - |
|
202 |
<username>pentaho</username>
|
| - |
|
203 |
<password>Encrypted 2be98afc86aa7f2e4cb79ac798cc2fd8a</password>
|
| - |
|
204 |
<servername/>
|
| - |
|
205 |
<data_tablespace/>
|
| - |
|
206 |
<index_tablespace/>
|
| - |
|
207 |
<attributes>
|
| - |
|
208 |
<attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
|
| - |
|
209 |
<attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute>
|
| - |
|
210 |
<attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
|
| - |
|
211 |
<attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
|
| - |
|
212 |
<attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
|
| - |
|
213 |
<attribute><code>PORT_NUMBER</code><attribute>3306</attribute></attribute>
|
| - |
|
214 |
<attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
|
| - |
|
215 |
<attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
|
| - |
|
216 |
<attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
|
| - |
|
217 |
<attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
|
| - |
|
218 |
</attributes>
|
| - |
|
219 |
</connection>
|
| 195 |
<order>
|
220 |
<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>
|
221 |
<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>
|
| 197 |
<step>
|
222 |
<step>
|
| 198 |
<name>items</name>
|
223 |
<name>items</name>
|
| 199 |
<type>TableInput</type>
|
224 |
<type>TableInput</type>
|
| Line 202... |
Line 227... |
| 202 |
<copies>1</copies>
|
227 |
<copies>1</copies>
|
| 203 |
<partitioning>
|
228 |
<partitioning>
|
| 204 |
<method>none</method>
|
229 |
<method>none</method>
|
| 205 |
<schema_name/>
|
230 |
<schema_name/>
|
| 206 |
</partitioning>
|
231 |
</partitioning>
|
| 207 |
<connection>catalogDC_local</connection>
|
232 |
<connection>catalogDC_Prod</connection>
|
| 208 |
<sql>SELECT SQL_NO_CACHE item.id, item.catalog_item_id, product_group, brand, model_number, model_name,
|
233 |
<sql>SELECT SQL_NO_CACHE item.id, item.catalog_item_id, product_group, brand, model_number, model_name,
|
| 209 |
color, category.label category, parent.label parent_category,
|
234 |
color, category.label category, parent.label parent_category,
|
| 210 |
case when sellingPrice < 2000 then 'a) 0-2000' when sellingPrice < 5000 then 'b) 2000-5000' when sellingPrice < 10000 then 'c) 5000-10000' when sellingPrice < 15000 then 'd) 10000-15000' when sellingPrice <20000 then 'e) 15000-20000' when sellingPrice < 50000 then 'f) 20000-50000' else 'g) More than 50000' end as price_range
|
235 |
case when sellingPrice < 2000 then 'a) 0-2000' when sellingPrice < 5000 then 'b) 2000-5000' when sellingPrice < 10000 then 'c) 5000-10000' when sellingPrice < 15000 then 'd) 10000-15000' when sellingPrice <20000 then 'e) 15000-20000' when sellingPrice < 50000 then 'f) 20000-50000' else 'g) More than 50000' end as price_range
|
| 211 |
FROM item, category, category as parent
|
236 |
FROM item, category, category as parent
|
| 212 |
where item.category = category.id
|
237 |
where item.category = category.id
|
| Line 380... |
Line 405... |
| 380 |
<copies>1</copies>
|
405 |
<copies>1</copies>
|
| 381 |
<partitioning>
|
406 |
<partitioning>
|
| 382 |
<method>none</method>
|
407 |
<method>none</method>
|
| 383 |
<schema_name/>
|
408 |
<schema_name/>
|
| 384 |
</partitioning>
|
409 |
</partitioning>
|
| 385 |
<connection>transaction_local</connection>
|
410 |
<connection>transProd</connection>
|
| 386 |
<sql>SELECT SQL_NO_CACHE 100000+id as id, 0 as catalog_item_id, 'Recharge' as product_group, name as brand, case when type = 2 then 'DTH' when type = 1 then 'Mobile' end as model_number, '' as model_name,
|
411 |
<sql>SELECT SQL_NO_CACHE 100000+id as id, 0 as catalog_item_id, 'Recharge' as product_group, name as brand, case when type = 2 then 'DTH' when type = 1 then 'Mobile' end as model_number, '' as model_name,
|
| 387 |
'N/A' as color, 'Recharge' as category, 'Digital' as parent_category,
|
412 |
'N/A' as color, 'Recharge' as category, 'Digital' as parent_category,
|
| 388 |
'N/A' as price_range
|
413 |
'N/A' as price_range
|
| 389 |
FROM serviceprovider </sql>
|
414 |
FROM serviceprovider </sql>
|
| 390 |
<limit>0</limit>
|
415 |
<limit>0</limit>
|