What is the difference between SQl Loader and OCI in datastage?

Answers were Sorted based on User's Feedback



What is the difference between SQl Loader and OCI in datastage?..

Answer / 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

What is the difference between SQl Loader and OCI in datastage?..

Answer / roshan nayak

An addition of above info through sqlldr we load bulk data
for this we use ora bulk stage. In this we load data
through script so data loaded in form of package. But there
is some restriction also, when we load data (bulk) target
table should not have index. We generally load data in
table-partation like weekly,monthly. It is faster than OCI.

Where as through OCI we load data as sequence manar. we can
set buffer size as require to read or write data. Here no
need to remove index from table.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Data Stage Interview Questions

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,


Define APT_CONFIG in Datastage?

0 Answers  


Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,


1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,


How many types of sorting methods are available in datastage?

0 Answers  


Differentiate between operational datastage (ods) and data warehouse?

0 Answers  


What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  


what is datastage job Monitoring

6 Answers   CTS,


How to manage date conversion in Datastage?

0 Answers  


Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,


What are system variables and sequencers in datastage

0 Answers  


j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,


Categories