What is the difference between SQl Loader and OCI in datastage?
Answer Posted / andy vaidya
SQL Loader (sqlldr) is a bulk loader utility from Oracle
for loading data into Oracle tables where as DataStage OCI
(Oracle Call Inteface) is a passive stage that connects to
any Oracle Database and collects necessary data and passes
it on to Datastage ETL for processing and applying
transformation where necessary and loads into target table.
DataStage OCI offers input and output stages for
conveniently connecting to Oracle Source databases and
Target Oracle databases.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Difference between server jobs & parallel jobs?
How to read the length of word in unix?
Give an idea of system variables.
Where do you see different stages in the designer?
project Steps,hits, Project level HArd things,Solved methods?
how to export or import the jobs in .ISX file
How to reverse the string using unix?
What is the difference between passive stage and active stage?
Differentiate between Join, Merge and Lookup stage?
What are the functionalities of link partitioner?
Can you highlight the main features of ibm infosphere information server?
What is datastage engine?
How do you reject records in a transformer?
What is a ds designer?
What are the functionalities of link collector?