Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the diff b/w odbc and oracle stage
- 2 Answers
- 20286 Views
- Accenture, HCL, I also Faced
- E-Mail Answers
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
How many types of views are there in a datastage director?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Explain the situation where you have applied SCD in your project?
how to implement scd2 in datastage 7.5 with lookup stage
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the types of containers in datastage?
What are the different layers in the information server architecture?
Which algorithm you used for your hashfile?
Distinguish between informatica & datastage. Which one would you choose and why?
Explain Quality stage?
Why we use surrogate key?
How do you remove duplicate values in datastage?
What is the difference between operational data stage (ods) and data warehouse?
