DBlink or joining two Oracle stages using lookup stage

atul sharma · Post by **atul sharma** » Thu May 15, 2008 3:28 pm

Hi All

I wanted to check with you all to see if using a dblink to fetch few more columns from a table in a different Oracle database would be better compard to use two Oracle enterprise stages and use a lookup between them.

Which one would be performance wise better.
When is it best to go for dblinks

Thanks

kumar_s · Post by **kumar_s** » Thu May 15, 2008 3:40 pm

Its depends up on the network connectivity. If ETL server has better bandwidth and better connectivity between the two DB server the the connection among the two DB server by it self, the Lookup option would be better.

atul sharma · Post by **atul sharma** » Thu May 15, 2008 4:07 pm

Thanks for your response Kumar.

Please correct me if I am wrong

I was of the opinion that, If we use a dblink and filter out the records in the user defined SQL and then use only one Oracle stage that would be fast.

Will the use of DBlink in the SQL a bigger overhead then joining two Oracle stages using lookup.

Thanks