Subversion Repositories SmartDukaan

Rev

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

Rev 2853 Rev 2856
Line 144... Line 144...
144 
    </attributes>
 144 
    </attributes>
145 
  </connection>
 145 
  </connection>
146 
  <order>
 146 
  <order>
147 
  <hop> <from>user</from><to>user_Mapping</to><enabled>Y</enabled> </hop>  <hop> <from>user_Mapping</from><to>user_DW</to><enabled>Y</enabled> </hop>  </order>
 147 
  <hop> <from>user</from><to>user_Mapping</to><enabled>Y</enabled> </hop>  <hop> <from>user_Mapping</from><to>user_DW</to><enabled>Y</enabled> </hop>  </order>
148 
  <step>
 148 
  <step>
- 
 
 149 
    <name>user</name>
- 
 
 150 
    <type>TableInput</type>
- 
 
 151 
    <description/>
- 
 
 152 
    <distribute>Y</distribute>
- 
 
 153 
    <copies>1</copies>
- 
 
 154 
         <partitioning>
- 
 
 155 
           <method>none</method>
- 
 
 156 
           <schema_name/>
- 
 
 157 
           </partitioning>
- 
 
 158 
    <connection>userDC_Prod</connection>
- 
 
 159 
    <sql>select id, email, name, is_anonymous, date_of_birth, sex, source,
- 
 
 160 
case when datediff(source_start_time, &apos;20101231&apos;) &gt; 0 then datediff(source_start_time, &apos;20101231&apos;) else 0 end as source_start_date_id,
- 
 
 161 
hour(source_start_time) as source_start_hour
- 
 
 162 
from user
- 
 
 163 
where is_anonymous = 0;</sql>
- 
 
 164 
    <limit>0</limit>
- 
 
 165 
    <lookup/>
- 
 
 166 
    <execute_each_row>N</execute_each_row>
- 
 
 167 
    <variables_active>N</variables_active>
- 
 
 168 
    <lazy_conversion_active>N</lazy_conversion_active>
- 
 
 169 
     <cluster_schema/>
- 
 
 170 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
- 
 
 171 
      <xloc>144</xloc>
- 
 
 172 
      <yloc>166</yloc>
- 
 
 173 
      <draw>Y</draw>
- 
 
 174 
      </GUI>
- 
 
 175 
    </step>
- 
 
 176 
 
- 
 
 177 
  <step>
149 
    <name>user_DW</name>
 178 
    <name>user_DW</name>
150 
    <type>TableOutput</type>
 179 
    <type>TableOutput</type>
151 
    <description/>
 180 
    <description/>
152 
    <distribute>Y</distribute>
 181 
    <distribute>Y</distribute>
153 
    <copies>1</copies>
 182 
    <copies>1</copies>
Line 208... Line 237...
208 
      <yloc>166</yloc>
 237 
      <yloc>166</yloc>
209 
      <draw>Y</draw>
 238 
      <draw>Y</draw>
210 
      </GUI>
 239 
      </GUI>
211 
    </step>
 240 
    </step>
212 
 
 241 
 
213 
  <step>
 - 
 
214 
    <name>user</name>
 - 
 
215 
    <type>TableInput</type>
 - 
 
216 
    <description/>
 - 
 
217 
    <distribute>Y</distribute>
 - 
 
218 
    <copies>1</copies>
 - 
 
219 
         <partitioning>
 - 
 
220 
           <method>none</method>
 - 
 
221 
           <schema_name/>
 - 
 
222 
           </partitioning>
 - 
 
223 
    <connection>userDC_Prod</connection>
 - 
 
224 
    <sql>select id, email, name, is_anonymous, date_of_birth, sex, source,
 - 
 
225 
case when datediff(source_start_time, &apos;20111231&apos;) &gt; 0 then datediff(source_start_time, &apos;20111231&apos;) else 0 end as source_start_date_id,
- 
 
226 
hour(source_start_time) as source_start_hour
 - 
 
227 
from user
- 
 
228 
where is_anonymous = 0;</sql>
 - 
 
229 
    <limit>0</limit>
 - 
 
230 
    <lookup/>
 - 
 
231 
    <execute_each_row>N</execute_each_row>
 - 
 
232 
    <variables_active>N</variables_active>
 - 
 
233 
    <lazy_conversion_active>N</lazy_conversion_active>
 - 
 
234 
     <cluster_schema/>
 - 
 
235 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 - 
 
236 
      <xloc>144</xloc>
 - 
 
237 
      <yloc>166</yloc>
 - 
 
238 
      <draw>Y</draw>
 - 
 
239 
      </GUI>
 - 
 
240 
    </step>
 - 
 
241 
 
 - 
 
242 
  <step>
 242 
  <step>
243 
    <name>user_Mapping</name>
 243 
    <name>user_Mapping</name>
244 
    <type>SelectValues</type>
 244 
    <type>SelectValues</type>
245 
    <description/>
 245 
    <description/>
246 
    <distribute>Y</distribute>
 246 
    <distribute>Y</distribute>