DSXchange

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..

What do you mean by "overwrite query" ?

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

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...

Reading using query join will be faster.

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.