wt is the diff b/w odbc and oracle stage
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 |
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
Define Data Stage?
Define repository tables in datastage?
What are some different alternative commands associated with "dsjob"?
What are iconv and oconv?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
how to call sequential generator in datastage?
Highlight the main features of datastage?
What are the components of ascential data stage?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
How many areas for files does datastage have?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?