NOTFOUND works fine when performing lookup on Hashed Files but for the Table lookup it is always better to use the null check.
sAM
New row in source is not loaded into target table
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Hi Sam,us1aslam1us wrote:NOTFOUND works fine when performing lookup on Hashed Files but for the Table lookup it is always better to use the null check.
sAM
Thank you for your input. You are correct. NOTFOUND would not work with database tables. To resolve this issue, my co-worker and I added an intermediate Hashed File stage and did a 'NOTFOUND' check on that. This worked and the row in question got loaded.
Thank you very much,
Seyed
Last edited by Seyed on Thu Apr 26, 2012 9:00 am, edited 1 time in total.
Craig,chulett wrote:Yes, always better because NOTFOUND doesn't really work for non-hashed file based lookups.
Hard to tell, though - is your lookup to a hashed file or directly to a database table?
Thank you as always. To answer your quesiton, I was originally using NOTFOUND on ODBC stage. After adding an extra step by feeding the data from and ODBC stage to a Hashed File stage, the NOTFOUND worked and the row in question got loaded.
Thank you and continued success,
Seyed