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......
