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..
overwrite query in OracleOCI stage-performance
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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...
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...
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: