Subversion Repositories SmartDukaan

Rev

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

Rev 3548 Rev 3594
Line 143... Line 143...
143 
    </attributes>
 143 
    </attributes>
144 
  </connection>
 144 
  </connection>
145 
  <order>
 145 
  <order>
146 
  <hop> <from>ordersMapping</from><to>orderfulfillmentDW</to><enabled>Y</enabled> </hop>  <hop> <from>orderfulfillments</from><to>ordersMapping</to><enabled>Y</enabled> </hop>  </order>
 146 
  <hop> <from>ordersMapping</from><to>orderfulfillmentDW</to><enabled>Y</enabled> </hop>  <hop> <from>orderfulfillments</from><to>ordersMapping</to><enabled>Y</enabled> </hop>  </order>
147 
  <step>
 147 
  <step>
- 
 
 148 
    <name>orderfulfillmentDW</name>
- 
 
 149 
    <type>TableOutput</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 
    <schema/>
- 
 
 159 
    <table>orderfulfillment</table>
- 
 
 160 
    <commit>1000</commit>
- 
 
 161 
    <truncate>Y</truncate>
- 
 
 162 
    <ignore_errors>N</ignore_errors>
- 
 
 163 
    <use_batch>Y</use_batch>
- 
 
 164 
    <specify_fields>N</specify_fields>
- 
 
 165 
    <partitioning_enabled>N</partitioning_enabled>
- 
 
 166 
    <partitioning_field/>
- 
 
 167 
    <partitioning_daily>N</partitioning_daily>
- 
 
 168 
    <partitioning_monthly>Y</partitioning_monthly>
- 
 
 169 
    <tablename_in_field>N</tablename_in_field>
- 
 
 170 
    <tablename_field/>
- 
 
 171 
    <tablename_in_table>Y</tablename_in_table>
- 
 
 172 
    <return_keys>N</return_keys>
- 
 
 173 
    <return_field/>
- 
 
 174 
    <fields>
- 
 
 175 
    </fields>
- 
 
 176 
     <cluster_schema/>
- 
 
 177 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
- 
 
 178 
      <xloc>630</xloc>
- 
 
 179 
      <yloc>161</yloc>
- 
 
 180 
      <draw>Y</draw>
- 
 
 181 
      </GUI>
- 
 
 182 
    </step>
- 
 
 183 
 
- 
 
 184 
  <step>
148 
    <name>orderfulfillments</name>
 185 
    <name>orderfulfillments</name>
149 
    <type>TableInput</type>
 186 
    <type>TableInput</type>
150 
    <description/>
 187 
    <description/>
151 
    <distribute>Y</distribute>
 188 
    <distribute>Y</distribute>
152 
    <copies>1</copies>
 189 
    <copies>1</copies>
Line 156... Line 193...
156 
           </partitioning>
 193 
           </partitioning>
157 
    <connection>transactionDC_Prod</connection>
 194 
    <connection>transactionDC_Prod</connection>
158 
    <sql>select datediff(o.created_timestamp, &apos;20101231&apos;) as date_id, o.logistics_provider_id, o.customer_pincode, o.status,
195 
    <sql>select datediff(o.created_timestamp, &apos;20101231&apos;) as date_id, o.logistics_provider_id, o.customer_pincode, o.status,
159 
l.item_id, datediff(o.expected_delivery_time, o.created_timestamp) as expected_delivery_days,
196 
l.item_id, datediff(o.expected_delivery_time, o.created_timestamp) as expected_delivery_days,
160 
datediff(o.delivery_timestamp, o.created_timestamp) as actual_delivery_days,
197 
datediff(o.delivery_timestamp, o.created_timestamp) as actual_delivery_days,
161 
datediff(o.delivery_timestamp, o.created_timestamp)-datediff(o.expected_delivery_time, o.created_timestamp) as actual_estimate_diff, o.delay_cause
 198 
datediff(o.delivery_timestamp, o.created_timestamp)-datediff(o.expected_delivery_time, o.created_timestamp) as actual_estimate_diff, o.delay_reason
162 
from `order` o
199 
from `order` o
163 
left join lineitem l on (o.id = l.order_id)
200 
left join lineitem l on (o.id = l.order_id)
164 
where o.status not in (0, 1)</sql>
 201 
where o.status not in (0, 1)</sql>
165 
    <limit>0</limit>
 202 
    <limit>0</limit>
166 
    <lookup/>
 203 
    <lookup/>
Line 215... Line 252...
215 
        <precision>-2</precision>
 252 
        <precision>-2</precision>
216 
      </field>      <field>        <name>actual_estimate_diff</name>
 253 
      </field>      <field>        <name>actual_estimate_diff</name>
217 
        <rename/>
 254 
        <rename/>
218 
        <length>-2</length>
 255 
        <length>-2</length>
219 
        <precision>-2</precision>
 256 
        <precision>-2</precision>
220 
      </field>      <field>        <name>delay_cause</name>
 257 
      </field>      <field>        <name>delay_reason</name>
221 
        <rename/>
 258 
        <rename/>
222 
        <length>-2</length>
 259 
        <length>-2</length>
223 
        <precision>-2</precision>
 260 
        <precision>-2</precision>
224 
      </field>        <select_unspecified>N</select_unspecified>
 261 
      </field>        <select_unspecified>N</select_unspecified>
225 
    </fields>     <cluster_schema/>
 262 
    </fields>     <cluster_schema/>
Line 228... Line 265...
228 
      <yloc>160</yloc>
 265 
      <yloc>160</yloc>
229 
      <draw>Y</draw>
 266 
      <draw>Y</draw>
230 
      </GUI>
 267 
      </GUI>
231 
    </step>
 268 
    </step>
232 
 
 269 
 
233 
  <step>
 - 
 
234 
    <name>orderfulfillmentDW</name>
 - 
 
235 
    <type>TableOutput</type>
 - 
 
236 
    <description/>
 - 
 
237 
    <distribute>Y</distribute>
 - 
 
238 
    <copies>1</copies>
 - 
 
239 
         <partitioning>
 - 
 
240 
           <method>none</method>
 - 
 
241 
           <schema_name/>
 - 
 
242 
           </partitioning>
 - 
 
243 
    <connection>salesDC_DW</connection>
 - 
 
244 
    <schema/>
 - 
 
245 
    <table>orderfulfillment</table>
 - 
 
246 
    <commit>1000</commit>
 - 
 
247 
    <truncate>Y</truncate>
 - 
 
248 
    <ignore_errors>N</ignore_errors>
 - 
 
249 
    <use_batch>Y</use_batch>
 - 
 
250 
    <specify_fields>N</specify_fields>
 - 
 
251 
    <partitioning_enabled>N</partitioning_enabled>
 - 
 
252 
    <partitioning_field/>
 - 
 
253 
    <partitioning_daily>N</partitioning_daily>
 - 
 
254 
    <partitioning_monthly>Y</partitioning_monthly>
 - 
 
255 
    <tablename_in_field>N</tablename_in_field>
 - 
 
256 
    <tablename_field/>
 - 
 
257 
    <tablename_in_table>Y</tablename_in_table>
 - 
 
258 
    <return_keys>N</return_keys>
 - 
 
259 
    <return_field/>
 - 
 
260 
    <fields>
 - 
 
261 
    </fields>
 - 
 
262 
     <cluster_schema/>
 - 
 
263 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 - 
 
264 
      <xloc>630</xloc>
 - 
 
265 
      <yloc>161</yloc>
 - 
 
266 
      <draw>Y</draw>
 - 
 
267 
      </GUI>
 - 
 
268 
    </step>
 - 
 
269 
 
 - 
 
270 
  <step_error_handling>
 270 
  <step_error_handling>
271 
  </step_error_handling>
 271 
  </step_error_handling>
272 
   <slave-step-copy-partition-distribution>
 272 
   <slave-step-copy-partition-distribution>
273 
</slave-step-copy-partition-distribution>
 273 
</slave-step-copy-partition-distribution>
274 
   <slave_transformation>N</slave_transformation>
 274 
   <slave_transformation>N</slave_transformation>