DSXchange

Hi All,

I crreated the job with Hash file out put with 4 key(A,B,C,D) colums.

but one of the requiremnet I need to reference this hash file as reference and in that I want to Join only one key colum (A), remain 3 key colums are not required to me. when do this job but its throughin error not compileing not match key colum. how to mask these 3 key in reference. is it possible can use only key colum?

thanks
BMSK

In a Hashed File stage you must use the entire key.

You can use a UniVerse stage if you want to use a partial key.

And then expect multiple matches on that partial key. And you'll need to create an index over it if you have any performance issues.

No My requirement in file level I can't use the Universe stage. draw back is that the job which is going to join is the Primary key there and here hash key combination columm not availble in that file. Only one colum availble. if select both side single key selection records are not coming.

Then rebuild the hashed file (or build another) with your single key field.

BMSK wrote:I can't use the Universe stage.

Why not?
A UniVerse table IS a hashed file.