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.