look up
Posted: Sat May 09, 2009 12:54 am
hi All,
I have below two requirements to do lookup please suggest me and correct me if i am using wrong stage for my requirement.
1. Requirement 1 is that all records coming from the database should match the sequential file processing_dt.
If matches then only those records are taken in to ouput
Ans:- I am using a lookup procesing stage , for checking if processes date matches then include those records.
So in condition tab of look up i am writing a constraint if process_dt of file is equal to process_dt of table
2. Requirement2 is that all the above matching reocrds should again check for the other file to get description value. so i am again using look up stage , is this correct way to do...
Can i have four lookup stages in the job or it's gd idea to have a join stage?
Please let me knw whch is performance wise good i have everyday 1million records to be exceuted
I have below two requirements to do lookup please suggest me and correct me if i am using wrong stage for my requirement.
1. Requirement 1 is that all records coming from the database should match the sequential file processing_dt.
If matches then only those records are taken in to ouput
Ans:- I am using a lookup procesing stage , for checking if processes date matches then include those records.
So in condition tab of look up i am writing a constraint if process_dt of file is equal to process_dt of table
2. Requirement2 is that all the above matching reocrds should again check for the other file to get description value. so i am again using look up stage , is this correct way to do...
Can i have four lookup stages in the job or it's gd idea to have a join stage?
Please let me knw whch is performance wise good i have everyday 1million records to be exceuted