I am loading data from a Fact table to an Aggregate table, doing lookup on two hash files.
Some of the data gets rejected as it cannot find it in the the lookup in the hashed file.
I have defined a stage variable stgNotFound as
Code: Select all
if (hashA.NOTFOUND or hashB.NOTFOUND) then 'N' else 'Y'
Code: Select all
stgNotFound = 'N'
Code: Select all
stgNotFound = 'Y'.
Also the number the Output Rows + Reject Rows is not equal to the Input Rows.
Any clues as to where i am going wrong??