Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the diff b/w odbc and oracle stage
- 2 Answers
- 20135 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 are the important features of datastage?
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
how to configure databases through datastage
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
What are the some differences between 7.x and 8.x version of datastage?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
How did you reconcile source with target?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
How to convert alpha Numeric values to alpha using functions?
Difference between the Sequence and Sequencer in DS?
Teradata 
