Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the diff b/w odbc and oracle stage
- 2 Answers
- 20273 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
What are the different type of jobs in datastage?
How many types of sorting methods are available in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Define Merge?
What are stage variables, derivations and constants?
What is the use of datastage director?
What are the stages in datastage?
How can you write parallel routines in datastage PX?
how to export or import the jobs in .ISX file
What a datastage macro?
What are the different kinds of views available in a datastage director?
Give an idea of system variables.
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are the repository tables in datastage?
