lookup reject file warning

[fmou]

Hi,

If I use a sequential file as the reject file for the lookup stage, I always get the following warning:

Code: Select all

Warning: A sequential operator cannot preserve the partitioning of input data set on input port 0

How to solve the problem?
What if I do want to preserve the partitioning for the lookup stage's stream output?

Thanks

[pandeesh]

Please make use search functionality.
Search for "cannot preserve the partitioning"[/url]

[jwiles]

Write to a dataset or a fileset instead of a sequential file to preserve the partitioning. Sequential files are, by nature and name, sequential and are not partitioned, therefore you receive this valid warning (for your reject output).

Keep in mind that this warning is from the sequential file stage, not the lookup stage and concerns your reject output (based on your description). The "stream" or main output from the lookup is unaffected.

Regards,

[fmou]

Keep in mind that this warning is from the sequential file stage, not the lookup stage and concerns your reject output

but the solution I found is to fix the lookup stage, hence my question.

Thanks