Hi All,
Could you please explain me about the System Variables
1. @NUMPARTITIONS
2. @PARTITIONNUM
and want to know their behavior while generating a sequence number?
system variables @NUMPARTITIONS and @PARTITIONNUM : explain
Moderators: chulett, rschirm, roy
system variables @NUMPARTITIONS and @PARTITIONNUM : explain
Mohsin Khan
Datastage Consultant
Datastage Consultant
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
@NUMPARTITIONS is the count of number of partition used in your job design. If your number of partitions are 4 then
@NUMPARTITIONS=4
@PARTITIONNUM will be 0 for first partition and 1 for second partition and so on.
Using @NUMPARTITIONS,@PARTITIONNUM and @INROWNUM you can generate formula to create sequence number in parallel job.
@NUMPARTITIONS is the count of number of partition used in your job design. If your number of partitions are 4 then
@NUMPARTITIONS=4
@PARTITIONNUM will be 0 for first partition and 1 for second partition and so on.
Using @NUMPARTITIONS,@PARTITIONNUM and @INROWNUM you can generate formula to create sequence number in parallel job.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Yes
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/