Incorrect Record Count with Lookup

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
emeri1md
Participant
Posts: 33
Joined: Tue Jun 17, 2008 10:42 am

Incorrect Record Count with Lookup

Post by emeri1md »

I am using a lookup to join two datasets. When using the lookup, I get an incorrect record count along the reference link. I should be seeing 448, the actual number of records. Instead I get 2838, which is the number of records from the main link (which displays the correct value).

Is this a known issue? Does it affect how my lookup functions?

Thanks,

Matt
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

Is it in the display on in the director logs. The data on the director would be correct

In the display it would be incorrect at times.

Regards
Sreeni
siauchun84
Participant
Posts: 63
Joined: Mon Oct 20, 2008 12:01 am
Location: Malaysia

Post by siauchun84 »

Did you put any setting like reject the unmatch records in your lookup stage?
Kryt0n
Participant
Posts: 584
Joined: Wed Jun 22, 2005 7:28 pm

Post by Kryt0n »

That threw me first time I started using 8x. Haven't quite figured out what it is reporting... maybe the number of successful lookups although I'm sure I have hit a few times where that doesn't seem true... I've pretty much learnt to ignore it anyway
Post Reply