Hi,
i am not using any sequential file stage.But i am getting "sequential operator cannot preserve partitioning" error for the oracle database stage(DRS Stage).
I am doing 'Hash partitioning' in transformer stage and then loading data into Oracle Database through DRS stage.
Is it necessary to set 'clear' in preserve partitioning in transformer before loading into database.
Same Job performed well in Development as well as test Environments,but this problem occured only in production itself.
Does it required any environment setup there.
I think this error occurs when we are working with sequential stage ? but i am getting this at database stage.
Thanks,
aquilis...
sequential operator cannot preserve partitioning
Moderators: chulett, rschirm, roy
Search helps - check out this post.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
They point to a sequential operator, not necessarily to a sequential file stage. Any stage can be constrained, mandatorily or otherwise, to execute in sequential mode. It suggests that your database stage is constrained to execute in sequential mode.
But, be be certain, can you post the entire message so that we can be sure that the message is indeed coming from the stage you assert?
But, be be certain, can you post the entire message so that we can be sure that the message is indeed coming from the stage you assert?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.