Transformer warning

Murali518 · Post by **Murali518** » Mon Oct 01, 2007 7:20 am

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.

chulett · Post by **chulett** » Mon Oct 01, 2007 7:27 am

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.

kool78 · Post by **kool78** » Tue Oct 09, 2007 4:09 pm

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.

michaeld · Post by **michaeld** » Thu Sep 11, 2008 12:07 pm

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:-)

ray.wurlod · Post by **ray.wurlod** » Thu Sep 11, 2008 5:31 pm

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.