look ups in parrelel jobs
Posted: Fri Jan 20, 2006 3:44 am
Could You help me in the following issue in parrelel job
I have .
file A contains 1 millon records
file B,contains 1000 records.
Oracle Table C contains 1000 records
I want to select some columns from A,B and C based on a condition
A.id=B.id and B.id=C.id
1.Could you suggest the best way of choosing lookups ?
2.Is there any performance bottlenecks when we choose heterogenious lookups ( 1 in Flat file and 1 in oracle)
3.Is there any advatage of chhoosing lookup_file set as lookup/s?
4.There will be some chance of addition of new records to oracle table
how can i make the changes visible in look up automatically.
I have .
file A contains 1 millon records
file B,contains 1000 records.
Oracle Table C contains 1000 records
I want to select some columns from A,B and C based on a condition
A.id=B.id and B.id=C.id
1.Could you suggest the best way of choosing lookups ?
2.Is there any performance bottlenecks when we choose heterogenious lookups ( 1 in Flat file and 1 in oracle)
3.Is there any advatage of chhoosing lookup_file set as lookup/s?
4.There will be some chance of addition of new records to oracle table
how can i make the changes visible in look up automatically.