sequential operator cannot preserve partitioning
Posted: Wed Mar 05, 2008 8:21 am
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...
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...