<gatewayDocument>
  <name>Customers_Transformation.gateway</name>
  <description>ETL Sample transformation</description>
  <author>Charles Martin</author>
  <creationDate>2011-12-06</creationDate>
  <lastModificationDate>2011-12-06</lastModificationDate>
  <version></version>
  <icon></icon>
  <flyover></flyover>
  <projectName></projectName>
  <projectVersion></projectVersion>
  <mode>0</mode>
  <servers>
    <dataBaseServer>
      <dataBaseConnection>
        <name>demo_sampledata</name>
        <description></description>
        <useFullUrl>true</useFullUrl>
        <fullUrl>jdbc:mysql://localhost:3306/sampledata</fullUrl>
        <login>biplatform</login>
        <password>biplatform</password>
        <driverName>MySQL</driverName>
      </dataBaseConnection>
      <name>demo_sampledata</name>
      <description></description>
    </dataBaseServer>
  </servers>
  <parameters/>
  <localVariables/>
  <forms/>
  <dataBaseInputStream>
    <name>Extraction</name>
    <description></description>
    <positionX>74</positionX>
    <positionY>82</positionY>
    <serverRef>demo_sampledata</serverRef>
    <outputVariables/>
    <definition><![CDATA[SELECT customers.customernumber, customers.customername, customers.creditlimit FROM customers]]></definition>
    <temporaryFileName>{$ENV_GATEWAY_TEMP}new DataBaseInputStream</temporaryFileName>
    <temporarySeparator>;</temporarySeparator>
  </dataBaseInputStream>
  <filter>
    <name>FilterCredit</name>
    <description></description>
    <positionX>223</positionX>
    <positionY>80</positionY>
    <exclusive>false</exclusive>
    <temporaryFileName>{$ENV_GATEWAY_TEMP}new Filter</temporaryFileName>
    <temporarySeparator>;</temporarySeparator>
    <condition>
      <elementName>Extraction::creditlimit</elementName>
      <operator>&gt;</operator>
      <value>30000</value>
      <logical>0</logical>
      <outputRef>Key</outputRef>
    </condition>
    <fields>
      <fieldName>customernumber</fieldName>
      <fieldName>customername</fieldName>
      <fieldName>creditlimit</fieldName>
    </fields>
  </filter>
  <surrogateKey>
    <name>Key</name>
    <description></description>
    <positionX>517</positionX>
    <positionY>80</positionY>
    <temporaryFileName>{$ENV_GATEWAY_TEMP}new SurrogateKey</temporaryFileName>
    <temporarySeparator>;</temporarySeparator>
    <fieldName>surrogateKey</fieldName>
    <keyName>Extraction::customernumber</keyName>
    <keyName>Extraction::customername</keyName>
    <keyName>Extraction::creditlimit</keyName>
  </surrogateKey>
  <calculation>
    <name>Calculation</name>
    <description></description>
    <positionX>223</positionX>
    <positionY>205</positionY>
    <temporaryFileName>{$ENV_GATEWAY_TEMP}new Calculation</temporaryFileName>
    <temporarySeparator>;</temporarySeparator>
    <script>
      <name>Date_Insertion</name>
      <expression>new Date()</expression>
      <type>0</type>
    </script>
  </calculation>
  <dataBaseOutputStream>
    <name>Insertion</name>
    <description></description>
    <positionX>517</positionX>
    <positionY>205</positionY>
    <truncate>true</truncate>
    <serverRef>demo_sampledata</serverRef>
    <definition>select daily_etl.id, daily_etl.customer_id, daily_etl.customer_name, daily_etl.customer_credit, daily_etl.date_etl from daily_etl</definition>
    <temporaryFileName>{$ENV_GATEWAY_TEMP}new DataBaseOutputStream</temporaryFileName>
    <temporarySeparator>;</temporarySeparator>
    <inputMappingName>
      <transformationRef>Calculation</transformationRef>
      <inputName>Key::customername</inputName>
      <outputName>customer_name</outputName>
    </inputMappingName>
    <inputMappingName>
      <transformationRef>Calculation</transformationRef>
      <inputName>Key::customernumber</inputName>
      <outputName>customer_id</outputName>
    </inputMappingName>
    <inputMappingName>
      <transformationRef>Calculation</transformationRef>
      <inputName>Key::creditlimit</inputName>
      <outputName>customer_credit</outputName>
    </inputMappingName>
    <inputMappingName>
      <transformationRef>Calculation</transformationRef>
      <inputName>Calculation::Date_Insertion</inputName>
      <outputName>date_etl</outputName>
    </inputMappingName>
    <inputMappingName>
      <transformationRef>Calculation</transformationRef>
      <inputName>Key::surrogateKey</inputName>
      <outputName>id</outputName>
    </inputMappingName>
    <fields>
      <fieldName>id</fieldName>
      <fieldName>customer_id</fieldName>
      <fieldName>customer_name</fieldName>
      <fieldName>customer_credit</fieldName>
      <fieldName>date_etl</fieldName>
    </fields>
  </dataBaseOutputStream>
  <link>
    <from>Extraction</from>
    <to>FilterCredit</to>
    <bendPoints/>
  </link>
  <link>
    <from>FilterCredit</from>
    <to>Key</to>
    <bendPoints/>
  </link>
  <link>
    <from>Key</from>
    <to>Calculation</to>
    <bendPoints/>
  </link>
  <link>
    <from>Calculation</from>
    <to>Insertion</to>
    <bendPoints/>
  </link>
</gatewayDocument>