odbc stage

dspxguy · Post by **dspxguy** » Tue May 20, 2008 11:29 am

To extract data from source using odbc stage , what needs to be done to get a better performance, considering we are using both server and parallel jobs.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue May 20, 2008 4:32 pm

Faster hardware, faster network, faster ODBC driver, more efficient queries ...

What does "performance" actually mean in an ETL context?

wesd · Post by **wesd** » Wed May 21, 2008 2:24 pm

Performance is in the eye of the user.

What's fast to you is slow to me, and v/v. Provide some performance numbers and target numbers and we'll talk.