Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

wt is the diff b/w odbc and oracle stage

Question Posted / vijay

Answers were Sorted based on User's Feedback



wt is the diff b/w odbc and oracle stage..

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

wt is the diff b/w odbc and oracle stage..

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

Post New Answer

More Data Stage Interview Questions

AGGREGATOR default datatype

0 Answers   CTS,

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

How do you find the number of rows in a sequential file?

1 Answers  

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 Answers  

How to remove blank spaces from data?

3 Answers  

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

For more Data Stage Interview Questions Click Here
Categories