I do a look up on the target database before loading the data.
I tried it with six records and my job worked....then when i tried it with 1500 records the job just froze.....and now i cant access the target table either...how do i correct it.....
the lookup is done on a DB2 stage and the target is also the same DB2 stage...
Should I separate this in to two jobs ? That is to load the contents to a has file in one job...and then use that hash file as a lookup in the second job ???
Will this fix ?? Pls advice
Job Does not Load...Hangs up
Moderators: chulett, rschirm, roy