DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Aquilis
Participant



Joined: 05 Apr 2007
Posts: 195
Location: Bangalore
Points: 2224

Post Posted: Wed Mar 05, 2008 8:21 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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...

_________________
Aquilis
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 15813
Location: Germany
Points: 89282

Post Posted: Wed Mar 05, 2008 8:23 am Reply with quote    Back to top    

Search helps - check out this post .

_________________

Image
Rate this response:  
Not yet rated
Aquilis
Participant



Joined: 05 Apr 2007
Posts: 195
Location: Bangalore
Points: 2224

Post Posted: Wed Mar 05, 2008 8:28 am Reply with quote    Back to top    

I have searched all the posts,those all point to sequential file stage. But i am getting this error in Database stage.so the solution will be same for all the stages.

Thanks,
aquilis..

_________________
Aquilis
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 51341
Location: Canberra, Australia
Points: 278774

Post Posted: Wed Mar 05, 2008 3:19 pm Reply with quote    Back to top    

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

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours