What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14070 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
What is the difference between hashfile and sequential file?
How will you move hashed file from one location to another location?
How to create a doccument in datastage?
What all are the different way to run a job?
How do you run datastage job from the command line?
what is the differeces between hash and modulus partition methods
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.
what is the use of materialized view?
How many Nodes configuration file you used in your last project?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
how to find no.of records in sequntial file itself?
Teradata 
