DSXchange

I was able to find a workaround: 1. Change target column in Transformer to CHAR(9) 2. Add the derivation "DecimalToString(Lnk_read_from_source.FO_PRO_PCT)" 3. Let the Teradata database do the implicit conversion from CHAR(9) to DECIMAL(7,7) Job runs perfectly now. I will mark this thread a...

Hi all, I'm puzzled by the following scenario: The job structure is as follows: SeqFile---------->Transformer---------->Teradata MultiLoad One of the columns in the SeqFile is defined as DECIMAL(7,7) NULL. In the Transformer, I transfer it unchanged to a DECIMAL(7,7) NULL column. The target Teradata...

Yes...good point. We've talked about the importance of minimizing datasets, but emphasizing clean-up is always a good thing...thanks.

Hi everyone, Our team currently has "dev" and "test" projects configured on a single SMP box. This box is dedicated to running DataStage only...no other applications are running on it. Each of these projects currently has its own configuration file pointing to dedicated disk and scratchdisk resource...

Our group is attempting to use the STP stage to invoke mainframe DB2 stored procedures. Our DBA is telling us that we somehow need to pass a "Collection ID" as part of our stored procedure call in order to properly invoke it. So far, the best solution we have is for the DBA to hard-code the collecti...