Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the diff b/w odbc and oracle stage
- 2 Answers
- 20137 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 |
what is the use of surogate key in datastage
What is the difference between operational data stage (ods) and data warehouse?
What is the purpose of pivot stage and types of containers in datastage
sed,awk,head
Define orabulk and bcp stages?
How a source file is populated?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
what is diff b/w datastage 8.1,8.5,8.7?
What is the difference between odbc and drs stage?
Teradata 
