Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the diff b/w odbc and oracle stage
- 2 Answers
- 20291 Views
- Accenture, HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bi etl
ODBC Stage require few connectivites to connect where are
Oracle just we can connect with server details.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can you implement SCD2 using join, transformer and funnel stage?
what are the errors,warnings in datastage
How to Convert the columns into rows?
how to export or import the jobs in .ISX file
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
Could anyone give brief explanation bout datastage admin
Hi Vijay here For Four CPU's how many nodes will required?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
Two source files contains same meta data third file contains different data types can I funnel that file.
State the difference between an operational datastage and a data warehouse?
Can you explain players in datastage?
Describe stream connector?
Teradata 
