Unable to load data in hash file

[smrutiranjannayak]

Hi Gurus ,

I am facing the following problem :

In my job the following sequence has been maintained :

OCI stage ......> Transformer...>Hash File ...>

From Oci stage 54 rows flowing same is from Transformer output link .
But when we are viewing Hashfile data we can only see 2 rows

We have 2 keys in Hashfile . ( branch no and acct no)
In table for 1 branch no there is morethan 1 acct no .


Data is as follows:

Accnbr Branchnbr
-------- -----------

1234 11
12
14
etc .

Result :

1234 11


Query ?

Please let me know why this is happening .
Is there any alternate to handle this scenario .

[ArndW]

Are you certain that you clicked the "key" tick box for the two columns in the hashed file stage? Which are the 2 keys that are currently being shown in the hashed file?

[smrutiranjannayak]

We have clicked the box for both keys....as well as we have taken care all conditions in hash file....

Unable to track the error . Please help.

[ArndW]

Make a copy of the job, replace the hashed file stage with a sequential file stage and look at the output, if it still makes no sense please post an excerpt from the sequential file.

[ray.wurlod]

You must regenerate the account number for every row in which there is only a branch number. You can not load a NULL key into a hashed file.

You can't load any data at all into a hash file, because there's no such thing in DataStage - it's a hashed file.