Subversion Repositories SmartDukaan

Rev

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

Rev 2597 Rev 2834
Line 141... Line 141...
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 
  <order>
 145 
  <order>
146 
  <hop> <from>orders</from><to>orderJoin</to><enabled>Y</enabled> </hop>  <hop> <from>datedim</from><to>orderJoin</to><enabled>Y</enabled> </hop>  <hop> <from>orderJoin</from><to>ordersMapping</to><enabled>Y</enabled> </hop>  <hop> <from>ordersMapping</from><to>salesDW</to><enabled>Y</enabled> </hop>  </order>
 146 
  <hop> <from>ordersMapping</from><to>salesDW</to><enabled>Y</enabled> </hop>  <hop> <from>orders</from><to>ordersMapping</to><enabled>Y</enabled> </hop>  </order>
147 
  <step>
 - 
 
148 
    <name>datedim</name>
 - 
 
149 
    <type>TableInput</type>
 - 
 
150 
    <description/>
 - 
 
151 
    <distribute>Y</distribute>
 - 
 
152 
    <copies>1</copies>
 - 
 
153 
         <partitioning>
 - 
 
154 
           <method>none</method>
 - 
 
155 
           <schema_name/>
 - 
 
156 
           </partitioning>
 - 
 
157 
    <connection>salesDC_DW</connection>
 - 
 
158 
    <sql>SELECT
- 
 
159 
date_id,
 - 
 
160 
fulldate &apos;date&apos;
 - 
 
161 
FROM datedim</sql>
 - 
 
162 
    <limit>0</limit>
 - 
 
163 
    <lookup/>
 - 
 
164 
    <execute_each_row>N</execute_each_row>
 - 
 
165 
    <variables_active>N</variables_active>
 - 
 
166 
    <lazy_conversion_active>N</lazy_conversion_active>
 - 
 
167 
     <cluster_schema/>
 - 
 
168 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 - 
 
169 
      <xloc>93</xloc>
 - 
 
170 
      <yloc>205</yloc>
 - 
 
171 
      <draw>Y</draw>
 - 
 
172 
      </GUI>
 - 
 
173 
    </step>
 - 
 
174 
 
 - 
 
175 
  <step>
 - 
 
176 
    <name>orderJoin</name>
 - 
 
177 
    <type>JoinRows</type>
 - 
 
178 
    <description/>
 - 
 
179 
    <distribute>Y</distribute>
 - 
 
180 
    <copies>1</copies>
 - 
 
181 
         <partitioning>
 - 
 
182 
           <method>none</method>
 - 
 
183 
           <schema_name/>
 - 
 
184 
           </partitioning>
 - 
 
185 
      <directory>%%java.io.tmpdir%%</directory>
 - 
 
186 
      <prefix>out</prefix>
 - 
 
187 
      <cache_size>500</cache_size>
 - 
 
188 
      <main/>
 - 
 
189 
    <compare>
 - 
 
190 
<condition>
 - 
 
191 
 <negated>N</negated>
 - 
 
192 
 <conditions>
 - 
 
193 
  <condition>
 - 
 
194 
   <negated>N</negated>
 - 
 
195 
   <leftvalue>order_date</leftvalue>
 - 
 
196 
   <function>=</function>
 - 
 
197 
   <rightvalue>date</rightvalue>
 - 
 
198 
   </condition>
 - 
 
199 
  </conditions>
 - 
 
200 
 </condition>
 - 
 
201 
    </compare>
 - 
 
202 
     <cluster_schema/>
 - 
 
203 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 - 
 
204 
      <xloc>225</xloc>
 - 
 
205 
      <yloc>163</yloc>
 - 
 
206 
      <draw>Y</draw>
 - 
 
207 
      </GUI>
 - 
 
208 
    </step>
 - 
 
209 
 
 - 
 
210 
  <step>
 147 
  <step>
211 
    <name>orders</name>
 148 
    <name>orders</name>
212 
    <type>TableInput</type>
 149 
    <type>TableInput</type>
213 
    <description/>
 150 
    <description/>
214 
    <distribute>Y</distribute>
 151 
    <distribute>Y</distribute>
Line 218... Line 155...
218 
           <schema_name/>
 155 
           <schema_name/>
219 
           </partitioning>
 156 
           </partitioning>
220 
    <connection>transactionDC_Prod</connection>
 157 
    <connection>transactionDC_Prod</connection>
221 
    <sql>SELECT  o.id &apos;order_id&apos;, o.customer_id, o.customer_pincode,
158 
    <sql>SELECT  o.id &apos;order_id&apos;, o.customer_id, o.customer_pincode,
222 
o.status &apos;order_status&apos;, o.total_amount,
159 
o.status &apos;order_status&apos;, o.total_amount,
223 
date(o.created_timestamp) as order_date, hour(o.created_timestamp) as order_hour,
 160 
datediff(o.created_timestamp, &apos;20110101&apos;) as date_id, hour(o.created_timestamp) as order_hour,
224 
o.transaction_id, l.item_id, l.quantity, l.unit_price, l.transfer_price, p.gatewayId,
161 
o.transaction_id, l.item_id, l.quantity, l.unit_price, l.transfer_price, p.gatewayId,
225 
pa.value &apos;payment_method&apos;
162 
pa.value &apos;payment_method&apos;, t.coupon_code
226 
FROM `order` o
163 
FROM `order` o
227 
left join lineitem l on(o.id = l.order_id )
164 
left join lineitem l on(o.id = l.order_id )
228 
left join payment.payment p on (o.transaction_id = p.merchantTxnId)
165 
left join payment.payment p on (o.transaction_id = p.merchantTxnId)
229 
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = &apos;payMethod&apos;)
 166 
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = &apos;payMethod&apos;)
- 
 
 167 
left join transaction t on (o.transaction_id = t.id)
230 
group by order_id</sql>
 168 
group by order_id</sql>
231 
    <limit>0</limit>
 169 
    <limit>0</limit>
232 
    <lookup/>
 170 
    <lookup/>
233 
    <execute_each_row>N</execute_each_row>
 171 
    <execute_each_row>N</execute_each_row>
234 
    <variables_active>N</variables_active>
 172 
    <variables_active>N</variables_active>
235 
    <lazy_conversion_active>N</lazy_conversion_active>
 173 
    <lazy_conversion_active>N</lazy_conversion_active>
236 
     <cluster_schema/>
 174 
     <cluster_schema/>
237 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 175 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
238 
      <xloc>98</xloc>
 176 
      <xloc>133</xloc>
239 
      <yloc>113</yloc>
 177 
      <yloc>160</yloc>
240 
      <draw>Y</draw>
 178 
      <draw>Y</draw>
241 
      </GUI>
 179 
      </GUI>
242 
    </step>
 180 
    </step>
243 
 
 181 
 
244 
  <step>
 182 
  <step>
Line 250... Line 188...
250 
         <partitioning>
 188 
         <partitioning>
251 
           <method>none</method>
 189 
           <method>none</method>
252 
           <schema_name/>
 190 
           <schema_name/>
253 
           </partitioning>
 191 
           </partitioning>
254 
    <fields>      <field>        <name>order_id</name>
 192 
    <fields>      <field>        <name>order_id</name>
255 
        <rename>order_id</rename>
 - 
 
256 
        <length>-2</length>
 193 
        <rename/>
257 
        <precision>-2</precision>
 - 
 
258 
      </field>      <field>        <name>transaction_id</name>
 - 
 
259 
        <rename>transaction_id</rename>
 - 
 
260 
        <length>-2</length>
 194 
        <length>-2</length>
261 
        <precision>-2</precision>
 195 
        <precision>-2</precision>
262 
      </field>      <field>        <name>customer_id</name>
 196 
      </field>      <field>        <name>customer_id</name>
263 
        <rename>customer_id</rename>
 197 
        <rename/>
264 
        <length>-2</length>
 198 
        <length>-2</length>
265 
        <precision>-2</precision>
 199 
        <precision>-2</precision>
266 
      </field>      <field>        <name>customer_pincode</name>
 200 
      </field>      <field>        <name>total_amount</name>
267 
        <rename>pincode</rename>
 201 
        <rename/>
268 
        <length>-2</length>
 202 
        <length>-2</length>
269 
        <precision>-2</precision>
 203 
        <precision>-2</precision>
270 
      </field>      <field>        <name>date_id</name>
 204 
      </field>      <field>        <name>date_id</name>
271 
        <rename>date_id</rename>
 205 
        <rename/>
272 
        <length>-2</length>
 206 
        <length>-2</length>
273 
        <precision>-2</precision>
 207 
        <precision>-2</precision>
274 
      </field>      <field>        <name>item_id</name>
 208 
      </field>      <field>        <name>order_hour</name>
275 
        <rename>item_id</rename>
 209 
        <rename/>
276 
        <length>-2</length>
 210 
        <length>-2</length>
277 
        <precision>-2</precision>
 211 
        <precision>-2</precision>
278 
      </field>      <field>        <name>quantity</name>
 212 
      </field>      <field>        <name>transaction_id</name>
279 
        <rename>quantity</rename>
 213 
        <rename/>
280 
        <length>-2</length>
 214 
        <length>-2</length>
281 
        <precision>-2</precision>
 215 
        <precision>-2</precision>
282 
      </field>      <field>        <name>unit_price</name>
 216 
      </field>      <field>        <name>item_id</name>
283 
        <rename>unit_price</rename>
 217 
        <rename/>
284 
        <length>-2</length>
 218 
        <length>-2</length>
285 
        <precision>-2</precision>
 219 
        <precision>-2</precision>
286 
      </field>      <field>        <name>order_status</name>
 220 
      </field>      <field>        <name>quantity</name>
287 
        <rename>status</rename>
 221 
        <rename/>
288 
        <length>-2</length>
 222 
        <length>-2</length>
289 
        <precision>-2</precision>
 223 
        <precision>-2</precision>
290 
      </field>      <field>        <name>total_amount</name>
 224 
      </field>      <field>        <name>unit_price</name>
291 
        <rename>total_amount</rename>
 225 
        <rename/>
292 
        <length>-2</length>
 226 
        <length>-2</length>
293 
        <precision>-2</precision>
 227 
        <precision>-2</precision>
294 
      </field>      <field>        <name>transfer_price</name>
 228 
      </field>      <field>        <name>transfer_price</name>
295 
        <rename>transfer_price</rename>
 229 
        <rename/>
296 
        <length>-2</length>
 230 
        <length>-2</length>
297 
        <precision>-2</precision>
 231 
        <precision>-2</precision>
298 
      </field>      <field>        <name>gatewayId</name>
 232 
      </field>      <field>        <name>gatewayId</name>
299 
        <rename>gatewayId</rename>
 233 
        <rename/>
300 
        <length>-2</length>
 234 
        <length>-2</length>
301 
        <precision>-2</precision>
 235 
        <precision>-2</precision>
302 
      </field>      <field>        <name>payment_method</name>
 236 
      </field>      <field>        <name>payment_method</name>
303 
        <rename>payment_method</rename>
 237 
        <rename/>
304 
        <length>-2</length>
 238 
        <length>-2</length>
305 
        <precision>-2</precision>
 239 
        <precision>-2</precision>
- 
 
 240 
      </field>      <field>        <name>customer_pincode</name>
- 
 
 241 
        <rename>pincode</rename>
- 
 
 242 
        <length>-2</length>
- 
 
 243 
        <precision>-2</precision>
306 
      </field>      <field>        <name>order_hour</name>
 244 
      </field>      <field>        <name>order_status</name>
307 
        <rename>order_hour</rename>
 245 
        <rename>status</rename>
- 
 
 246 
        <length>-2</length>
- 
 
 247 
        <precision>-2</precision>
- 
 
 248 
      </field>      <field>        <name>coupon_code</name>
- 
 
 249 
        <rename/>
308 
        <length>-2</length>
 250 
        <length>-2</length>
309 
        <precision>-2</precision>
 251 
        <precision>-2</precision>
310 
      </field>        <select_unspecified>N</select_unspecified>
 252 
      </field>        <select_unspecified>N</select_unspecified>
311 
    </fields>     <cluster_schema/>
 253 
    </fields>     <cluster_schema/>
312 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 254 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>