Error in retrieving records using look up
Posted: Tue Dec 14, 2010 6:07 am
Hi All,
I'm facing issue while doing look up of sequential file and dataset file.
Actually In source I'm using Sequential file with Session_id(varchar),Page_number(varchar),Hour_of_day(varchar) columns and same columns coming from reference dataset file but unique records.
I'm doing look up on SESSION_ID column.From source I'm getting duplicate session_id's and from reference unique records.
In source file I'm having 2990204 records and in reference 206775 records.
But while executing I'm seesing 2990204 records coming out from referenceinstead of 206775 records.
Could any one please let me know where i'm going wrong?
I'm facing issue while doing look up of sequential file and dataset file.
Actually In source I'm using Sequential file with Session_id(varchar),Page_number(varchar),Hour_of_day(varchar) columns and same columns coming from reference dataset file but unique records.
I'm doing look up on SESSION_ID column.From source I'm getting duplicate session_id's and from reference unique records.
In source file I'm having 2990204 records and in reference 206775 records.
But while executing I'm seesing 2990204 records coming out from referenceinstead of 206775 records.
Could any one please let me know where i'm going wrong?