Dataset lookup
Posted: Wed May 12, 2004 9:07 am
Hi,
Why the number of the records from Dataset (that gets displayed in monitor window) reference link in a dataset lookup always match the the primary link's number of records ? I created a dataset with 20,000 records in Job X. In Job Y, i use this dataset as a reference link. Primary link has about 3000 records. When i ran the job Y, the show performance stat. is giving me 3000 records on primary link and 3000 records (instead of 20,000) on reference link. Any reason why ? Is it doing some sort of join even before the lookup internally ?
Thanks.
Raj.
Why the number of the records from Dataset (that gets displayed in monitor window) reference link in a dataset lookup always match the the primary link's number of records ? I created a dataset with 20,000 records in Job X. In Job Y, i use this dataset as a reference link. Primary link has about 3000 records. When i ran the job Y, the show performance stat. is giving me 3000 records on primary link and 3000 records (instead of 20,000) on reference link. Any reason why ? Is it doing some sort of join even before the lookup internally ?
Thanks.
Raj.