Warnings in Hash File.....

[MaheshKumar Sugunaraj]

Hi All,

I have executed a Job

LooKUp(HashFile)
|
|
Hashfile ----> Transformer -----> HashFile

Is the setup of the Job,

The job is compling and after the execution of the Job, I get the following Warning messages

*************************************************************

Program "JOB.1861650351.DT.1333058567.TRANS1": Line 300, Attempted WRITE with NULL record ID

Program "DSD.UVClose": Line 56, Attempted WRITE with NULL record ID

DataStage Phantom Finished

*************************************************************

Could anybody Please help me with this.

Thanks & Regards
SMK

[chulett]

It means pretty much exactly what it says: You are allowing null key values to be written to your target hash. This is a Bad Thing.

[sumitgulati]

To find out the culprit records you can use constraints in the transformer on key columns. Push all the records with Null Key values to a sequential file and the one with Not Null Key values to the target hash file. This should help you in debugging.

Regards,
Sumit

[MaheshKumar Sugunaraj]

Thank you for your valuable suggestion,was able to check and rectify the issue.


Have a great day.


Thanks
SMK