What is the difference between drs and odbc stage - 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. 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 ... - DataStage Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

DATASTAGE

DETAILS

Question: What is the difference between drs and odbc stage

Answer: 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.

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 ...

Category	DataStage Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 7217 users
Added on	7/26/2011
Views	72528
Rate it!

Question: What is the difference between drs and odbc stage

Answer:

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.

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 ...
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	what is meaning of file extender in data stage server jobs. can we run the data stage job from one job to another job that file data where it is stored and what is the file extender in ds jobs.	View Answer
	How does DataStage handle the user security?	View Answer
	What are the Steps involved in development of a job in DataStage?	View Answer
	Briefly describe the various client components?	View Answer
	What is a project? Specify its various components?	View Answer
	* What are constraints and derivation? * Explain the process of taking backup in DataStage? *What are the different types of lookups available in DataStage?	View Answer
	Will the data stage consider the second constraint in the transformer once the first condition is satisfied ( if the link odering is given)	View Answer
	How to remove duplicates in server job	View Answer
	How do you do Usage analysis in datastage ?	View Answer
	Purpose of using the key and difference between Surrogate keys and natural key	View Answer
	What are the environment variables in datastage?give some examples?	View Answer
	wht is the difference beteen validated ok and compiled in datastage.	View Answer
	What is difference between Merge stage and Join stage?	View Answer
	How to implement type2 slowly changing dimenstion in datastage? give me with example?	View Answer
	How to find the number of rows in a sequential file?	View Answer
	Where actually the flat files store?what is the path?	View Answer
	What are the different types of lookups in datastage?	View Answer
	What are the most important aspects that a beginner must consider doin his first DS project ?	View Answer
	How we can call the routine in datastage job?explain with steps?	View Answer
	What is job control?how it is developed?explain with steps?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DataStage Interview Questions & Answers - Exam Mode / Learning Mode