hashed file
Posted: Mon May 29, 2006 4:30 am
hi guys ,
i have job like this
seq file(10records)-------->tranformer------>tranformer------>target
............................................||....................||
............................... hashed fil (same .
.............................. records what
.............................. i have in source)
lookup with two keys
i am getting output...i got a quary , is it neccssary preload the data in to the memory in this situation.
i know (total no of distict rows/total no of rows in the table)....
if i use that option it occupy lot of memory....performance
can any one help...
i have job like this
seq file(10records)-------->tranformer------>tranformer------>target
............................................||....................||
............................... hashed fil (same .
.............................. records what
.............................. i have in source)
lookup with two keys
i am getting output...i got a quary , is it neccssary preload the data in to the memory in this situation.
i know (total no of distict rows/total no of rows in the table)....
if i use that option it occupy lot of memory....performance
can any one help...