« Return to Thread: Reg:Target table details in .oli file

Reg:Target table details in .oli file

by PriyaSuresh :: Rate this Message:

Reply to Author | View in Thread

Hi ,
  I am using octopus GUI to load data.In generator GUI if give source table in source databse say ETLTEST
and target table in target database say ETLLoad, the generated .oli looks as,
    <importDefinition name="ETLTEST" tableName="ETLTEST ">
        <valueColumns>
            <valueColumn sourceColumnName="LEAD_OR_LAG " targetColumnName="LEAD_OR_LAG" targetTableID="0" targetTableName="ETLTEST " valueMode="Overwrite"/>
            <valueColumn sourceColumnName="VALUE " targetColumnName="VALUE" targetTableID="0" targetTableName="ETLTEST " valueMode="Overwrite"/>
                  <tables>
            <table insert="true" oidLogic="false" tableID="0" tableMode="Query" tableName="ETLTEST"/>
        </tables>
    </importDefinition>
All the details are source table dtls.So am maually changing the .oli file.How to  get the taregt table detals.Am i missing something or do we need to change it manually.Pl help...Thanks in advance......

 « Return to Thread: Reg:Target table details in .oli file