Solution to the large look-up
Posted: Mon Jul 30, 2007 7:48 am
Hi All,
I have a file coming in with 70,000 rows and has duplicates.For the unique combination of keys in the file I have to look up againest a DB2 table which has 70,000,000(70 million) rows.
I am thinking best way to do this is create a temorary table in DB2 with keys from the file and then do the join to the bigger table then do the rest of the processing.
Please let me know if there is any other best way to do this other than creating a DB2 Temporary table(for which I have to goto DBA)..
Thanks
nsm.
I have a file coming in with 70,000 rows and has duplicates.For the unique combination of keys in the file I have to look up againest a DB2 table which has 70,000,000(70 million) rows.
I am thinking best way to do this is create a temorary table in DB2 with keys from the file and then do the join to the bigger table then do the rest of the processing.
Please let me know if there is any other best way to do this other than creating a DB2 Temporary table(for which I have to goto DBA)..
Thanks
nsm.