Page 1 of 1

odbc stage

Posted: Tue May 20, 2008 11:29 am
by dspxguy
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

Posted: Tue May 20, 2008 4:32 pm
by ray.wurlod
Faster hardware, faster network, faster ODBC driver, more efficient queries ...

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

Posted: Wed May 21, 2008 2:24 pm
by wesd
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.