-
Training
Learn how Petra can help your employees be more productive with specialized one-on-one classes and mentoring
-
Members
Visit our member site where you will find a wealth of information from how to administer a DataStage implementation to best practices and beyond
-
Knowledge base
Search the knowledge base for answers to many of your questions
Knowledge Base
Weekly Tips
Q:
How do I increment a row counter that will be unique when running a parallel job with a configuration that has more than 1 node?
A:
Use the following algorithm in your transform to create a unique row count -
@PARTITIONNUM + ( @NUMPARTITIONS * ( @INROWNUM-1))
Copyright © 2012 Petra Business Systems, Inc, All Rights Reserved