Joiner is not finding match when hash partition is given

mary · Post by **mary** » Tue May 12, 2009 3:44 am

Using a joiner to match incoming and already exists in database based on one key column. But when we give partion as hash with key column as partition key.For some records it is not finding a match.If I remove partition it is working.. or if I give sequential in advanced joiner properties it is giving record is matched =true

Any clue?

mahadev.v · Post by **mahadev.v** » Tue May 12, 2009 4:15 am

Does the meta data for the key column match on both links to the join stage?
Note:- AFAIK there is nothing like a "joiner" in DataStage.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue May 12, 2009 4:15 am

Your question itself has the answer.

Partitioning affects the flow of records.

Think about it.

ray.wurlod · Post by **ray.wurlod** » Tue May 12, 2009 3:29 pm

Assuming that you are using a Join stage, have you sorted the inputs correctly?