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 |
What can we do with datastage director?
What are the areas of application?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
how many types of sorting the data in data stage?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
Can you explain tagbatch restructure operator?
What is the difference between an operational datastage and a data warehouse?
how to find out number of records imported into source file?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
What are the third party tools you used in your project?
what is the function in Transformer stage can act as Rank function in Oracle