Problem with performance
Posted: Thu Jun 22, 2006 9:10 am
Hi ,
I have a source ora stage & a lookup of hash file & writing output into a hash again , my source is have millions of record but out of tht i just wanna pick 100 of rec which are present in hash lookup ,prolem is tht even after writing that 100 rec into target it keeps on searching of that 100 frc in source which is not correct because its takes time , can any one suggest me a way where i can join data from values in hash , i mean it should be like equi join of oracle.
Thanks in advance.
I have a source ora stage & a lookup of hash file & writing output into a hash again , my source is have millions of record but out of tht i just wanna pick 100 of rec which are present in hash lookup ,prolem is tht even after writing that 100 rec into target it keeps on searching of that 100 frc in source which is not correct because its takes time , can any one suggest me a way where i can join data from values in hash , i mean it should be like equi join of oracle.
Thanks in advance.