Page 2 of 2
Posted: Mon Apr 26, 2010 7:21 am
by chulett
Assuming, of course, that this load happens in isolation.
Posted: Tue Jul 13, 2010 9:02 pm
by karthi_gana
jpMaxKeyValue + @INROWNUM
what abt jpMaxKeyValue + DSLinkRowcount?
Posted: Tue Jul 13, 2010 9:07 pm
by ray.wurlod
Too slow. The DSLinkCount macro has to begin an interrogation of the repository for every row processed. The link row count is already available in @OUTROWNUM (or @INROWNUM if an input link).
Posted: Tue Jul 13, 2010 9:12 pm
by karthi_gana
ray.wurlod wrote:Too slow. The DSLinkCount macro has to begin an interrogation of the repository for every row processed. The link row count is already available in @OUTROWNUM (or @INROWNUM if an input link).
Could you please explain it more?
Posted: Tue Jul 13, 2010 9:34 pm
by chulett
Why go back and query the repository every record, which is what the macro does, when you've already got the value you need in a system variable local to the transformer?
(if it starts with '@' it is a system variable, check the online help)