Subversion Repositories SmartDukaan

Rev

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

Rev 2704 Rev 2710
Line 164... Line 164...
164 
hour(checked_out_on) as checked_out_hour, hour(cart.created_on) as created_hour,
164 
hour(checked_out_on) as checked_out_hour, hour(cart.created_on) as created_hour,
165 
hour(cart.updated_on) as updated_hour
 165 
hour(cart.updated_on) as updated_hour
166 
from line, cart, address, user
 166 
from line, cart, address, user
167 
where cart.id = line.cart_id
167 
where cart.id = line.cart_id
168 
and (address_id = address.id or address_id is null)
168 
and (address_id = address.id or address_id is null)
169 
and cart_status = 1
169 
and user.active_cart_id = cart.id
170 
and user.id = cart.user_id
170 
and user.id = cart.user_id
171 
and user.is_anonymous = 0;</sql>
 171 
and user.is_anonymous = 0;</sql>
172 
    <limit>0</limit>
 172 
    <limit>0</limit>
173 
    <lookup/>
 173 
    <lookup/>
174 
    <execute_each_row>N</execute_each_row>
 174 
    <execute_each_row>N</execute_each_row>
Line 181... Line 181...
181 
      <draw>Y</draw>
 181 
      <draw>Y</draw>
182 
      </GUI>
 182 
      </GUI>
183 
    </step>
 183 
    </step>
184 
 
 184 
 
185 
  <step>
 185 
  <step>
- 
 
 186 
    <name>cart_DW</name>
- 
 
 187 
    <type>TableOutput</type>
- 
 
 188 
    <description/>
- 
 
 189 
    <distribute>Y</distribute>
- 
 
 190 
    <copies>1</copies>
- 
 
 191 
         <partitioning>
- 
 
 192 
           <method>none</method>
- 
 
 193 
           <schema_name/>
- 
 
 194 
           </partitioning>
- 
 
 195 
    <connection>salesDC</connection>
- 
 
 196 
    <schema/>
- 
 
 197 
    <table>cart</table>
- 
 
 198 
    <commit>1000</commit>
- 
 
 199 
    <truncate>Y</truncate>
- 
 
 200 
    <ignore_errors>N</ignore_errors>
- 
 
 201 
    <use_batch>Y</use_batch>
- 
 
 202 
    <specify_fields>N</specify_fields>
- 
 
 203 
    <partitioning_enabled>N</partitioning_enabled>
- 
 
 204 
    <partitioning_field/>
- 
 
 205 
    <partitioning_daily>N</partitioning_daily>
- 
 
 206 
    <partitioning_monthly>Y</partitioning_monthly>
- 
 
 207 
    <tablename_in_field>N</tablename_in_field>
- 
 
 208 
    <tablename_field/>
- 
 
 209 
    <tablename_in_table>Y</tablename_in_table>
- 
 
 210 
    <return_keys>N</return_keys>
- 
 
 211 
    <return_field/>
- 
 
 212 
    <fields>
- 
 
 213 
        <field>
- 
 
 214 
          <column_name>id</column_name>
- 
 
 215 
          <stream_name>id</stream_name>
- 
 
 216 
        </field>
- 
 
 217 
        <field>
- 
 
 218 
          <column_name>product_group</column_name>
- 
 
 219 
          <stream_name>product_group</stream_name>
- 
 
 220 
        </field>
- 
 
 221 
        <field>
- 
 
 222 
          <column_name>brand</column_name>
- 
 
 223 
          <stream_name>brand</stream_name>
- 
 
 224 
        </field>
- 
 
 225 
        <field>
- 
 
 226 
          <column_name>model_number</column_name>
- 
 
 227 
          <stream_name>model_number</stream_name>
- 
 
 228 
        </field>
- 
 
 229 
        <field>
- 
 
 230 
          <column_name>model_name</column_name>
- 
 
 231 
          <stream_name>model_name</stream_name>
- 
 
 232 
        </field>
- 
 
 233 
        <field>
- 
 
 234 
          <column_name>color</column_name>
- 
 
 235 
          <stream_name>color</stream_name>
- 
 
 236 
        </field>
- 
 
 237 
        <field>
- 
 
 238 
          <column_name>category</column_name>
- 
 
 239 
          <stream_name>category</stream_name>
- 
 
 240 
        </field>
- 
 
 241 
    </fields>
- 
 
 242 
     <cluster_schema/>
- 
 
 243 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
- 
 
 244 
      <xloc>576</xloc>
- 
 
 245 
      <yloc>160</yloc>
- 
 
 246 
      <draw>Y</draw>
- 
 
 247 
      </GUI>
- 
 
 248 
    </step>
- 
 
 249 
 
- 
 
 250 
  <step>
186 
    <name>cart_Mapping</name>
 251 
    <name>cart_Mapping</name>
187 
    <type>SelectValues</type>
 252 
    <type>SelectValues</type>
188 
    <description/>
 253 
    <description/>
189 
    <distribute>Y</distribute>
 254 
    <distribute>Y</distribute>
190 
    <copies>1</copies>
 255 
    <copies>1</copies>
Line 255... Line 320...
255 
      <yloc>164</yloc>
 320 
      <yloc>164</yloc>
256 
      <draw>Y</draw>
 321 
      <draw>Y</draw>
257 
      </GUI>
 322 
      </GUI>
258 
    </step>
 323 
    </step>
259 
 
 324 
 
260 
  <step>
 - 
 
261 
    <name>cart_DW</name>
 - 
 
262 
    <type>TableOutput</type>
 - 
 
263 
    <description/>
 - 
 
264 
    <distribute>Y</distribute>
 - 
 
265 
    <copies>1</copies>
 - 
 
266 
         <partitioning>
 - 
 
267 
           <method>none</method>
 - 
 
268 
           <schema_name/>
 - 
 
269 
           </partitioning>
 - 
 
270 
    <connection>salesDC</connection>
 - 
 
271 
    <schema/>
 - 
 
272 
    <table>cart</table>
 - 
 
273 
    <commit>1000</commit>
 - 
 
274 
    <truncate>Y</truncate>
 - 
 
275 
    <ignore_errors>N</ignore_errors>
 - 
 
276 
    <use_batch>Y</use_batch>
 - 
 
277 
    <specify_fields>N</specify_fields>
 - 
 
278 
    <partitioning_enabled>N</partitioning_enabled>
 - 
 
279 
    <partitioning_field/>
 - 
 
280 
    <partitioning_daily>N</partitioning_daily>
 - 
 
281 
    <partitioning_monthly>Y</partitioning_monthly>
 - 
 
282 
    <tablename_in_field>N</tablename_in_field>
 - 
 
283 
    <tablename_field/>
 - 
 
284 
    <tablename_in_table>Y</tablename_in_table>
 - 
 
285 
    <return_keys>N</return_keys>
 - 
 
286 
    <return_field/>
 - 
 
287 
    <fields>
 - 
 
288 
        <field>
 - 
 
289 
          <column_name>id</column_name>
 - 
 
290 
          <stream_name>id</stream_name>
 - 
 
291 
        </field>
 - 
 
292 
        <field>
 - 
 
293 
          <column_name>product_group</column_name>
 - 
 
294 
          <stream_name>product_group</stream_name>
 - 
 
295 
        </field>
 - 
 
296 
        <field>
 - 
 
297 
          <column_name>brand</column_name>
 - 
 
298 
          <stream_name>brand</stream_name>
 - 
 
299 
        </field>
 - 
 
300 
        <field>
 - 
 
301 
          <column_name>model_number</column_name>
 - 
 
302 
          <stream_name>model_number</stream_name>
 - 
 
303 
        </field>
 - 
 
304 
        <field>
 - 
 
305 
          <column_name>model_name</column_name>
 - 
 
306 
          <stream_name>model_name</stream_name>
 - 
 
307 
        </field>
 - 
 
308 
        <field>
 - 
 
309 
          <column_name>color</column_name>
 - 
 
310 
          <stream_name>color</stream_name>
 - 
 
311 
        </field>
 - 
 
312 
        <field>
 - 
 
313 
          <column_name>category</column_name>
 - 
 
314 
          <stream_name>category</stream_name>
 - 
 
315 
        </field>
 - 
 
316 
    </fields>
 - 
 
317 
     <cluster_schema/>
 - 
 
318 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 - 
 
319 
      <xloc>576</xloc>
 - 
 
320 
      <yloc>160</yloc>
 - 
 
321 
      <draw>Y</draw>
 - 
 
322 
      </GUI>
 - 
 
323 
    </step>
 - 
 
324 
 
 - 
 
325 
  <step_error_handling>
 325 
  <step_error_handling>
326 
  </step_error_handling>
 326 
  </step_error_handling>
327 
   <slave-step-copy-partition-distribution>
 327 
   <slave-step-copy-partition-distribution>
328 
</slave-step-copy-partition-distribution>
 328 
</slave-step-copy-partition-distribution>
329 
   <slave_transformation>N</slave_transformation>
 329 
   <slave_transformation>N</slave_transformation>