Subversion Repositories SmartDukaan

Rev

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

Rev 2519 Rev 2584
Line 91... Line 91...
91 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
 91 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
92 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
 92 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
93 
    </attributes>
 93 
    </attributes>
94 
  </connection>
 94 
  </connection>
95 
  <connection>
 95 
  <connection>
- 
 
 96 
    <name>transactionDC_local</name>
- 
 
 97 
    <server>localhost</server>
- 
 
 98 
    <type>MYSQL</type>
- 
 
 99 
    <access>Native</access>
- 
 
 100 
    <database>transaction</database>
- 
 
 101 
    <port>3306</port>
- 
 
 102 
    <username>root</username>
- 
 
 103 
    <password>Encrypted 2be98afc86aa7f2e4b811a1608cc2fd8a</password>
- 
 
 104 
    <servername/>
- 
 
 105 
    <data_tablespace/>
- 
 
 106 
    <index_tablespace/>
- 
 
 107 
    <attributes>
- 
 
 108 
      <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
- 
 
 109 
      <attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute>
- 
 
 110 
      <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
- 
 
 111 
      <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
- 
 
 112 
      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
- 
 
 113 
      <attribute><code>PORT_NUMBER</code><attribute>3306</attribute></attribute>
- 
 
 114 
      <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
- 
 
 115 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
- 
 
 116 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
- 
 
 117 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
- 
 
 118 
    </attributes>
- 
 
 119 
  </connection>
- 
 
 120 
  <connection>
96 
    <name>transactionDC_Prod</name>
 121 
    <name>transactionDC_Prod</name>
97 
    <server>192.168.141.43</server>
 122 
    <server>192.168.141.43</server>
98 
    <type>MYSQL</type>
 123 
    <type>MYSQL</type>
99 
    <access>Native</access>
 124 
    <access>Native</access>
100 
    <database>transaction</database>
 125 
    <database>transaction</database>
Line 191... Line 216...
191 
         <partitioning>
 216 
         <partitioning>
192 
           <method>none</method>
 217 
           <method>none</method>
193 
           <schema_name/>
 218 
           <schema_name/>
194 
           </partitioning>
 219 
           </partitioning>
195 
    <connection>transactionDC_Prod</connection>
 220 
    <connection>transactionDC_Prod</connection>
196 
    <sql>SELECT
- 
 
197 
o.id &apos;order_id&apos;,
 221 
    <sql>SELECT  o.id &apos;order_id&apos;, o.customer_id, o.customer_pincode,
198 
o.customer_id,
 - 
 
199 
o.customer_pincode,
 - 
 
200 
o.customer_city,
 - 
 
201 
o.customer_state,
 - 
 
202 
o.status &apos;order_status&apos;,
 222 
o.status &apos;order_status&apos;, o.total_amount,
203 
o.total_amount,
 - 
 
204 
date(o.created_timestamp) as order_date,
 223 
date(o.created_timestamp) as order_date, o.transaction_id, l.item_id,
205 
o.transaction_id,
 224 
l.quantity, l.unit_price, l.transfer_price, p.gatewayId, pa.value &apos;payment_method&apos;
206 
l.item_id,
 - 
 
207 
l.productGroup,
 225 
FROM `order` o
208 
l.brand,
 - 
 
209 
l.model_number,
 226 
left join lineitem l on(o.id = l.order_id )
210 
l.model_name,
 - 
 
211 
l.color,
 - 
 
212 
l.quantity,
 - 
 
213 
l.unit_price
 - 
 
214 
 
 - 
 
215 
FROM `order` o, lineitem l
 227 
left join payment.payment p on (o.transaction_id = p.merchantTxnId)
216 
WHERE o.id = l.order_id</sql>
 228 
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = &apos;payMethod&apos;)</sql>
217 
    <limit>0</limit>
 229 
    <limit>0</limit>
218 
    <lookup/>
 230 
    <lookup/>
219 
    <execute_each_row>N</execute_each_row>
 231 
    <execute_each_row>N</execute_each_row>
220 
    <variables_active>N</variables_active>
 232 
    <variables_active>N</variables_active>
221 
    <lazy_conversion_active>N</lazy_conversion_active>
 233 
    <lazy_conversion_active>N</lazy_conversion_active>
Line 236... Line 248...
236 
         <partitioning>
 248 
         <partitioning>
237 
           <method>none</method>
 249 
           <method>none</method>
238 
           <schema_name/>
 250 
           <schema_name/>
239 
           </partitioning>
 251 
           </partitioning>
240 
    <fields>      <field>        <name>order_id</name>
 252 
    <fields>      <field>        <name>order_id</name>
241 
        <rename>order_id</rename>
 253 
        <rename/>
242 
        <length>-2</length>
 254 
        <length>-2</length>
243 
        <precision>-2</precision>
 255 
        <precision>-2</precision>
244 
      </field>      <field>        <name>transaction_id</name>
 256 
      </field>      <field>        <name>transaction_id</name>
245 
        <rename>transaction_id</rename>
 257 
        <rename/>
246 
        <length>-2</length>
 258 
        <length>-2</length>
247 
        <precision>-2</precision>
 259 
        <precision>-2</precision>
248 
      </field>      <field>        <name>customer_id</name>
 260 
      </field>      <field>        <name>customer_id</name>
249 
        <rename>customer_id</rename>
 261 
        <rename/>
250 
        <length>-2</length>
 262 
        <length>-2</length>
251 
        <precision>-2</precision>
 263 
        <precision>-2</precision>
252 
      </field>      <field>        <name>customer_pincode</name>
 264 
      </field>      <field>        <name>customer_pincode</name>
253 
        <rename>pincode</rename>
 265 
        <rename>pincode</rename>
254 
        <length>-2</length>
 266 
        <length>-2</length>
255 
        <precision>-2</precision>
 267 
        <precision>-2</precision>
256 
      </field>      <field>        <name>date_id</name>
 268 
      </field>      <field>        <name>date_id</name>
257 
        <rename>date_id</rename>
 269 
        <rename/>
258 
        <length>-2</length>
 270 
        <length>-2</length>
259 
        <precision>-2</precision>
 271 
        <precision>-2</precision>
260 
      </field>      <field>        <name>item_id</name>
 272 
      </field>      <field>        <name>item_id</name>
261 
        <rename>item_id</rename>
 273 
        <rename/>
262 
        <length>-2</length>
 274 
        <length>-2</length>
263 
        <precision>-2</precision>
 275 
        <precision>-2</precision>
264 
      </field>      <field>        <name>quantity</name>
 276 
      </field>      <field>        <name>quantity</name>
265 
        <rename>quantity</rename>
 277 
        <rename/>
266 
        <length>-2</length>
 278 
        <length>-2</length>
267 
        <precision>-2</precision>
 279 
        <precision>-2</precision>
268 
      </field>      <field>        <name>unit_price</name>
 280 
      </field>      <field>        <name>unit_price</name>
269 
        <rename>unit_price</rename>
 281 
        <rename/>
270 
        <length>-2</length>
 282 
        <length>-2</length>
271 
        <precision>-2</precision>
 283 
        <precision>-2</precision>
272 
      </field>      <field>        <name>order_status</name>
 284 
      </field>      <field>        <name>order_status</name>
273 
        <rename>status</rename>
 285 
        <rename>status</rename>
274 
        <length>-2</length>
 286 
        <length>-2</length>
275 
        <precision>-2</precision>
 287 
        <precision>-2</precision>
- 
 
 288 
      </field>      <field>        <name>total_amount</name>
- 
 
 289 
        <rename/>
- 
 
 290 
        <length>-2</length>
- 
 
 291 
        <precision>-2</precision>
- 
 
 292 
      </field>      <field>        <name>transfer_price</name>
- 
 
 293 
        <rename/>
- 
 
 294 
        <length>-2</length>
- 
 
 295 
        <precision>-2</precision>
- 
 
 296 
      </field>      <field>        <name>gatewayId</name>
- 
 
 297 
        <rename/>
- 
 
 298 
        <length>-2</length>
- 
 
 299 
        <precision>-2</precision>
- 
 
 300 
      </field>      <field>        <name>payment_method</name>
- 
 
 301 
        <rename/>
- 
 
 302 
        <length>-2</length>
- 
 
 303 
        <precision>-2</precision>
276 
      </field>        <select_unspecified>N</select_unspecified>
 304 
      </field>        <select_unspecified>N</select_unspecified>
277 
    </fields>     <cluster_schema/>
 305 
    </fields>     <cluster_schema/>
278 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 306 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
279 
      <xloc>373</xloc>
 307 
      <xloc>371</xloc>
280 
      <yloc>160</yloc>
 308 
      <yloc>160</yloc>
281 
      <draw>Y</draw>
 309 
      <draw>Y</draw>
282 
      </GUI>
 310 
      </GUI>
283 
    </step>
 311 
    </step>
284 
 
 312 
 
Line 292... Line 320...
292 
           <method>none</method>
 320 
           <method>none</method>
293 
           <schema_name/>
 321 
           <schema_name/>
294 
           </partitioning>
 322 
           </partitioning>
295 
    <connection>salesDC_DW</connection>
 323 
    <connection>salesDC_DW</connection>
296 
    <schema/>
 324 
    <schema/>
297 
    <table>salesNew</table>
 325 
    <table>sales</table>
298 
    <commit>1000</commit>
 326 
    <commit>1000</commit>
299 
    <truncate>Y</truncate>
 327 
    <truncate>Y</truncate>
300 
    <ignore_errors>N</ignore_errors>
 328 
    <ignore_errors>N</ignore_errors>
301 
    <use_batch>Y</use_batch>
 329 
    <use_batch>Y</use_batch>
302 
    <specify_fields>N</specify_fields>
 330 
    <specify_fields>N</specify_fields>