wt is the diff b/w odbc and oracle stage
Answer Posted / jaimy chacko
ODBC stage can be used to connect to different databases like Oracle , DB2 ..etc . It can be connected to any databases with ODBC drivers where as ORACLE stage connects only to Oracle databases
If you want to connect to a Oracle database and you are using Oracle stage, it will be faster and better. ODBC stage also does the same but it will be slow and its generic ,, I suggest using ODBC stage where there is no specific plugins to connect to a database.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Difference between server jobs & parallel jobs?
Highlight the main features of datastage?
Where do the datastage jobs get stored?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
describe the Steps to confiure a Qlogic switch
What is the difference between informatica and datastage?
What are routines in datastage?
Can you explain engine tier in information server?
Define Routines and their types?
What are the differences between datastage and informatica?
What are the types of views in datastage director?
EXPLAIN SCD
Describe the main features of datastage?
Differentiate between hash file and sequential file?
What are the various kinds of containers available in datastage?