<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Descriptor xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">
    <descCacheLookup>
        <descCacheLookup>
            <columnNamesRowNumber>1</columnNamesRowNumber>
            <headerRowsNumber>1</headerRowsNumber>
            <parameters/>
            <lookupName>Look1</lookupName>
            <keyColumns>
                <keyColumns>LASTNAME</keyColumns>
            </keyColumns>
            <outputColumns>
                <outputColumns>ADDRESS</outputColumns>
                <outputColumns>NUM</outputColumns>
            </outputColumns>
            <readerDescriptor>
                <path>jdbc:oracle:thin:@degano:1521:cadit</path>
                <type>DB</type>
                <Columns>
                    <_columns>
                        <decimalSeparator>,</decimalSeparator>
                        <groupingSeparator>.</groupingSeparator>
                        <length>32</length>
                        <name>LASTNAME</name>
                        <ColumnType>STRING</ColumnType>
                    </_columns>
                    <_columns>
                        <decimalSeparator>,</decimalSeparator>
                        <groupingSeparator>.</groupingSeparator>
                        <length>32</length>
                        <name>ADDRESS</name>
                        <ColumnType>STRING</ColumnType>
                    </_columns>
                    <_columns>
                        <decimalSeparator>,</decimalSeparator>
                        <groupingSeparator>.</groupingSeparator>
                        <length>3</length>
                        <name>NUM</name>
                        <ColumnType>INT</ColumnType>
                    </_columns>
                </Columns>
                <columnNamesRowNumber>1</columnNamesRowNumber>
                <headerRowsNumber>1</headerRowsNumber>
                <parameters>
                    <parameter name="dbType">Oracle</parameter>
                    <parameter name="username">mmsvi</parameter>
                    <parameter name="password">mmsvi</parameter>
                    <parameter name="mappa"></parameter>
                    <parameter name="query">select * from TABLELOOKUP</parameter>
                </parameters>
            </readerDescriptor>
        </descCacheLookup>
    </descCacheLookup>
    <descReader>
        <path>\\nas_sistemirete\Syshw\CORSI\AlternanzaScuolaLavoro\DemoSprint2\utentiBancaCSV.csv</path>
        <type>CSV</type>
        <Columns>
            <_columns>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>24</length>
                <name>Name</name>
                <ColumnType>STRING</ColumnType>
            </_columns>
            <_columns>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>24</length>
                <name>Last Name</name>
                <ColumnType>STRING</ColumnType>
            </_columns>
            <_columns>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>20</length>
                <name>Registration Date</name>
                <pattern>dd/MM/yyyy</pattern>
                <ColumnType>DATE</ColumnType>
            </_columns>
            <_columns>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>12</length>
                <name>Balance</name>
                <pattern>#,###.##</pattern>
                <ColumnType>DECIMAL</ColumnType>
            </_columns>
        </Columns>
        <columnNamesRowNumber>1</columnNamesRowNumber>
        <headerRowsNumber>1</headerRowsNumber>
        <parameters>
            <parameter name="Separator">;</parameter>
        </parameters>
    </descReader>
    <descWriter>
        <Type>FixedLength</Type>
        <Path>\\nas_sistemirete\Syshw\CORSI\AlternanzaScuolaLavoro\DemoSprint2\utentiBancaFormattato.txt</Path>
        <IsAppended>false</IsAppended>
        <columns>
            <column>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>24</length>
                <name>Name</name>
                <ColumnType>STRING</ColumnType>
            </column>
            <column>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>24</length>
                <name>Last Name</name>
                <ColumnType>STRING</ColumnType>
            </column>
            <column>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>20</length>
                <name>Registration Date</name>
                <pattern>dd/MM/yyyy</pattern>
                <ColumnType>DATE</ColumnType>
            </column>
            <column>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>15</length>
                <name>Balance</name>
                <pattern>#,###.##</pattern>
                <ColumnType>DECIMAL</ColumnType>
            </column>
            <column>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>32</length>
                <name>ADDRESS</name>
                <ColumnType>STRING</ColumnType>
            </column>
            <column>
                <decimalSeparator>,</decimalSeparator>
                <groupingSeparator>.</groupingSeparator>
                <length>3</length>
                <name>NUM</name>
                <ColumnType>INT</ColumnType>
            </column>
        </columns>
        <writeHeadColumns>true</writeHeadColumns>
        <parameters/>
    </descWriter>
    <transformers>
        <descTransform>
            <type>Mapper</type>
            <mapTypes>
                <_parameters name="TypesMapper">MAP|MAP|MAP|MAP</_parameters>
                <_parameters name="Values">[Name|Name][LASTNAME|Last Name][Registration Date|Registration Date][Balance|Balance]</_parameters>
            </mapTypes>
            <parameters>
                <parameter name="TypesMapper">MAP|MAP|MAP|MAP</parameter>
                <parameter name="Values">[Name|Name][LASTNAME|Last Name][Registration Date|Registration Date][Balance|Balance]</parameter>
            </parameters>
        </descTransform>
        <descTransform>
            <type>Lookup</type>
            <mapTypes>
                <_parameters name="OutputColumns">ADDRESS|NUM</_parameters>
                <_parameters name="KeyColumns">LASTNAME</_parameters>
                <_parameters name="NameCache">Look1</_parameters>
            </mapTypes>
            <parameters>
                <parameter name="OutputColumns">ADDRESS|NUM</parameter>
                <parameter name="KeyColumns">LASTNAME</parameter>
                <parameter name="NameCache">Look1</parameter>
            </parameters>
        </descTransform>
        <descTransform>
            <type>Mapper</type>
            <mapTypes>
                <_parameters name="TypesMapper">MAP|MAP|MAP|MAP|MAP|MAP</_parameters>
                <_parameters name="Values">[Name|Name][Last Name|LASTNAME][Registration Date|Registration Date][Balance|Balance][NUM|NUM][ADDRESS|ADDRESS]</_parameters>
            </mapTypes>
            <parameters>
                <parameter name="TypesMapper">MAP|MAP|MAP|MAP|MAP|MAP</parameter>
                <parameter name="Values">[Name|Name][Last Name|LASTNAME][Registration Date|Registration Date][Balance|Balance][NUM|NUM][ADDRESS|ADDRESS]</parameter>
            </parameters>
        </descTransform>
    </transformers>
    <globalVariables/>
</Descriptor>