Page 1 of 1
wht is DRS stage
Posted: Thu Dec 01, 2005 10:14 am
by venkat n
what is DRS stage?
Differences between DRS Stage and ODBC? Which one is the best for performance?
Posted: Thu Dec 01, 2005 10:26 am
by kcbland
ODBC uses the ODBC driver for a particular database, DRS is a stage that tries to make it seamless for switching from one database to another. It uses the native connectivities for the chosen target database.
Please read your manuals, this is clearly documented.
Posted: Thu Dec 01, 2005 10:28 am
by Bala R
Dynamic Relational Stage was leveraged for Peoplesoft to have a job to run on any of the supported databases. It supports ODBC connections too. Read more of that in the plug-in documentation.
Posted: Thu Dec 01, 2005 3:59 pm
by ray.wurlod
Seems to me you need to work on your employer to get you some training! Shouldn't be too difficult, since your employer is the vendor!
Posted: Thu Dec 01, 2005 4:34 pm
by vmcburney
To answer your question the DRS stage should be faster then the ODBC stage as it uses native database connectivity. You will need to install and configure the required database clients on your DataStage server for it to work.