Hello!

I tried to build a simple Job in order to evaluate the ETL-capabilities of TOS.
I used the components tELTOracleInput, tELTOracleOutput and tELTOracleMap in order achieve an inner Join between two Table s1, s2 inserting the result into table trg. The generated SQL was correct and the job worked well.

INSERT INTO DISPO_SPIEL.TRG(SCHL_ID,VAL_1,VAL_2)
(SELECT J1.SCHL_ID, J1.VAL_1 , J2.VAL_2
FROM  DISPO_SPIEL.S1 J1 INNER JOIN  DISPO_SPIEL.S2 J2
ON(  J2.SCHL_ID = J1.SCHL_ID  ))

But when I save, close and re-open the job it seems to be corrupted. When running it,  I'm getting a "Too  many values" - Error, as  the generated SQL has changed to

INSERT INTO DISPO_SPIEL.TRG(SCHL_ID,VAL_1,VAL_2)
(SELECT J1.SCHL_ID, J1.VAL_1 , J2.VAL_2, J1.SCHL_ID, J1.VAL_1 , J2.VAL_2
FROM  DISPO_SPIEL.S1 J1 INNER JOIN  DISPO_SPIEL.S2 J2
ON(  J2.SCHL_ID = J1.SCHL_ID  AND  J2.SCHL_ID = J1.SCHL_ID  ))

I am able to "restore" the correct version by going into the tELTOracleMap - editor and pressing update, but particularly with regard to exporting the job this behaviour seems to be a severe problem.
I am using TOS 4.0.1 with Java.

Thanks in advance for any advice.

Regards
Alexander