Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the diff b/w odbc and oracle stage
- 2 Answers
- 20129 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
how to export or import the jobs in .ISX file
What are the types of containers and how to create them?
How the ipc stage work?
What are sequencers?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the types of hashed files in data stage
What is a quality stage in datastage tool?
What is the differentiate between data file and descriptor file?
If you want to use the same piece of code in different jobs, how will you achieve it?
Why do you need stage variables?
Describe the architecture of datastage?
what is the use of skid in reporting?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are constraints and derivations?
Explain entity, attribute and relationship in datastage?
