DSXchange

Create a sequence "seq_order_no" in database. And now where ever you call "seq_order_no.nextval", you ll get the sequence number from database. This will be assigned to VOM_ORDER_NO. So no need to assign anything in Transformer stage for sequence no. Transformer will deliver the record from VOM_ORDE...

Do you mean to say, the records with Primary key is not captured? Has the Key been marked in the Transformer Stage?

What type of rejected records, you think are not captured? Rejected with what error code?

Welcome Aboard :D !!!! On general approach, Buildops ar used for the functionality which may not be acheivable or difficult to acheive by using existing stages. Say eg, looping or some complex transfomation logic which involves some iteration of the string etc., "I agree buildops are efficient compa...

If you have already used "REJECTED" from LinkVariables option in Transformer, and not able to capture all the rows, you need to find the reason of rejection. You can find this from Director log.
You ll need to handle it accordingly. You may even need to do a lookup on target before loading the data.

And if those lookup tables "Package..." doesn't gets changed for each run, you can isolate the population Hashed file into separate job. So that you can avoid some unnecessary IO.

seq_order_no.nextval is Database function not Datastage function.
So remove this column from Datastage, and re arrange the order of the columns starting from :1,:2... rather than :2,:3 etc.

May be the version that you work has a bug in it. Better approach your Support.

You need to do Hash Partition on Col1 for both right and left dataset on sort stage. And maintain SAME partition in Join stage for both the link.

So you should check the data value that been extracted from Sequential file.
Dont you get any other error message other that the noted one?

No.
Not just using Sort stage, but may be using Sort coupled with Transformer and its stage variables.

Try changing read/write/execute/sticky for the owner.
-rwsr-xr-s for jobmoninit.

Actually it would be in .../Ascential/DataStage/PXEngine.7.51.1/java
Do you find any log find available there as JobMonApp.log.nnnn?
Who is the owner for jobmoninit?
Has't setuid/setgid bit been set for this?

Hope you can mark the topic as resolved.

Thanks for sharing it Sakthi.