Search found 33 matches

by Kel
Mon May 11, 2015 10:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Output from aggregator & xformer to single sequential ta
Replies: 3
Views: 1339

Output from aggregator & xformer to single sequential ta

I have 3 input links: 2 from aggregator stages and 1 from transformer that must be moved to a single target file. What would be the stage to be used? We cannot use funnel since fields are all unique. Responses will be very much appreciated.
by Kel
Mon May 11, 2015 7:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Transformation Error
Replies: 7
Views: 6382

The output of my look up stage has 5 columns and was used as an input to the transformer stage. I used a stage variable with the following derivation. ($V_CST_REPCTOT:Lnk_D_CL_VAL_ID_DMRFN.COSTOS_TOTALES = Lnk_D_CL_VAL_ID_DMRFN.UNQ_SRC_STM_ID) OR ($V_CST_ACSTMTDLV :Lnk_D_CL_VAL_ID_DMRFN.EXTRACTO_VIR...
by Kel
Mon May 11, 2015 3:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Transformation Error
Replies: 7
Views: 6382

Datastage Transformation Error

Hello, Im receiving the following errors on my datastage parallel job. the input came from a lookup stage. My Transformer stage has 2 outputs, one which is null when the derivation is -3 , and the other is not null where table1.a=a and table1.b=b. can some1 help. Output from transformer compilation ...