wt is the diff b/w odbc and oracle stage
- 2 Answers
- 19162 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 |
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
what is datastage job Monitoring
what is combinability and non combinability?
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
Nls stands for what in datastage?
I have a few records just I want to store each records tow times in target how?
what is time dimension? and how to populate time demension
source file is having 5 records while moving into target it want to be 10 records
Teradata 
