Page 1 of 1

Transformer warning

Posted: Mon Oct 01, 2007 7:20 am
by Murali518
Hi all,
When I run a job which is having specific partition type for a tranformer stage, I'm getting the below warning:-
Transformer_18: Input Dataset 0 has partitioning other than Entire specified; disabling memory sharing.

Can anyone tell me why it is coming and how to stop it.

thanks,
Murali.

Posted: Mon Oct 01, 2007 7:27 am
by chulett
Welcome!

Actually, you can discover on your own what your warning message is all about by Searching the forums. Take a portion of your message not specific to your job - say, "has partitioning other than Entire specified; disabling memory sharing" - and do an Exact Match search. You'll find it has been discussed here in the past.

Posted: Tue Oct 09, 2007 4:09 pm
by kool78
This is a known bug in DataStage, if you explicity specify a partition in Transformer Stage it throws this Warning message.

You can add this warning to an Existing Message handler or new Message handler in your project and demote it to Informational.

Posted: Thu Sep 11, 2008 12:07 pm
by michaeld
The other thing you can do is insert a COPY stage just before your transforer and set the partitioning there. In the transforer just leave it as default(AUTO). This worked for me. I hate DataStage, but at least it pays my mortgage:-)

Posted: Thu Sep 11, 2008 5:31 pm
by ray.wurlod
kool78 wrote:This is a known bug in DataStage, if you explicity specify a partition in Transformer Stage it throws this Warning message.

You can add this warning to an Existing Message handler or new Message handler in your project and demote it to Informational.
It's not a bug, as I've explained before. It's an alert that the designers of DataStage felt ought to be issued.