Passing datas from hashed files to the where clause
Posted: Tue Mar 25, 2008 11:29 am
Hi All,
Is there a way of passing the values from the hashed file to the Where clause of the sql.
Let me explain
1.My source system is like this
table1------table2
table1-------table3
table1 -------table4.
All are related through primary key(table1 pk in table2,table3,table4)
Filter condition for my specfic requirement fetches only 2 rows from my first table1.So i am storing it in the hash files.
I want to generate hash files for table2,table3,table4 based on the filter condtion of table1 which i am using it latter for integration.
Fetching all the records from table2,table3,table3 and creating hash files by looking up with table1 solves the requirement but i am extracting again and again the same millions and millions of rows.
No CDC logic as the system is not timestamped anywhere.
If i pass these values to my table 2 in where clause then only those records from table 2,table3,table4 are going to be feteched and then i can hash it.
Any inputs most appreciated.
Regards,
Bala.
Is there a way of passing the values from the hashed file to the Where clause of the sql.
Let me explain
1.My source system is like this
table1------table2
table1-------table3
table1 -------table4.
All are related through primary key(table1 pk in table2,table3,table4)
Filter condition for my specfic requirement fetches only 2 rows from my first table1.So i am storing it in the hash files.
I want to generate hash files for table2,table3,table4 based on the filter condtion of table1 which i am using it latter for integration.
Fetching all the records from table2,table3,table3 and creating hash files by looking up with table1 solves the requirement but i am extracting again and again the same millions and millions of rows.
No CDC logic as the system is not timestamped anywhere.
If i pass these values to my table 2 in where clause then only those records from table 2,table3,table4 are going to be feteched and then i can hash it.
Any inputs most appreciated.
Regards,
Bala.