overwrite query in OracleOCI stage-performance

vinsashi · Post by **vinsashi** » Mon Dec 07, 2009 3:09 am

Hi,
I Have two tables .Daily i will get 0.1 million records.i have to join two tables with key column and i have to retrieve one column from other table.
i have overwrite query in oracle oci stage(i used join query itself) is inthis way good performance wise or using lookup performance good
which process better...

Thanks
v..

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Dec 07, 2009 3:27 am

What do you mean by "overwrite query" ?

Doing the join in database is certainly faster than in DataStage - with few exceptions.

vinsashi · Post by **vinsashi** » Mon Dec 07, 2009 3:36 am

Hi,

i have two tables transcation,product
TXN
txn_id
pd_id
rev

in product
pd_id
pd_nm

in output i want this target is hashfile
pd_id
txn_id
pd_nm
rev

procedure1:
i will write query it self in database stage
procedure2;
using transformer and source and refrence as tables(lookup in server )

In both which way better

Thanks
v...

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Dec 07, 2009 3:39 am

Reading using query join will be faster.

chulett · Post by **chulett** » Mon Dec 07, 2009 8:06 am

For something like that, I doubt there will be any appreciable difference in the execution speeds. Use the hashed file reference methodology when the join isn't as dead simple as that one, for example when the table to be 'joined' resides in another database.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 07, 2009 3:56 pm

Moderator: please move to server forum