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

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,


What is the difference between hashfile and sequential file?

0 Answers  


How will you move hashed file from one location to another location?

0 Answers   NTT Data,


How to create a doccument in datastage?

1 Answers   Cap Gemini,


What all are the different way to run a job?

0 Answers  


How do you run datastage job from the command line?

0 Answers  


what is the differeces between hash and modulus partition methods

4 Answers   TCS,


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.

1 Answers   IBM,


what is the use of materialized view?

0 Answers   CTS,


How many Nodes configuration file you used in your last project?

1 Answers  


In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,


how to find no.of records in sequntial file itself?

4 Answers  


Categories