Explain the difference between drs and odbc stage?
Submitted by: AdministratorTo 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.
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.
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
Submitted by: Administrator
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.
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
Submitted by: Administrator
Read Online Warehouse DataStage Job Interview Questions And Answers
Top Warehouse DataStage Questions
☺ | How to fix the error "OCI has fetched truncated data" in DataStage? |
☺ | How to kill the job in data stage? |
☺ | Explain What does a Config File in parallel extender consist of? |
☺ | Explain How to handle the rejected rows in datastage? |
☺ | What is iconv and oconv functions? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |