wt is the diff b/w odbc and oracle stage
- 2 Answers
- 19164 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
Can you implement SCD2 using join, transformer and funnel stage?
What is difference between join, merge and lookup stage?
Why do we use link partitioner and link collector in datastage?
Describe stream connector?
What is the flow of loading data into fact & dimensional tables?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Notification Activity
Describe the architecture of datastage?
What are the different plug-ins stages used in your projects?
Why do we use exception activity in Datastage?
Give an idea of system variables.
what is flow of project?
Why do you need stage variables?
options available in sequence job to run,validate?
How do you schedule or monitoring the job?
