Generating sequence numbers using Stage variables

chulett · Post by **chulett** » Mon Apr 26, 2010 7:21 am

Assuming, of course, that this load happens in isolation.

karthi_gana · Post by **karthi_gana** » Tue Jul 13, 2010 9:02 pm

jpMaxKeyValue + @INROWNUM

what abt jpMaxKeyValue + DSLinkRowcount?

ray.wurlod · Post by **ray.wurlod** » Tue Jul 13, 2010 9:07 pm

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

karthi_gana · Post by **karthi_gana** » Tue Jul 13, 2010 9:12 pm

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?

chulett · Post by **chulett** » Tue Jul 13, 2010 9:34 pm

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)