Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14962 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to reverse the string using unix?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
what is the use of materialized view?
How a source file is populated?
What all are the different way to run a job?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How do you run datastage job from the command line?
What are the different types of lookups in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the difference types of stages?
Highlight the main features of datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
describe the Steps to confiure a Qlogic switch
What is the difference between server job and parallel jobs?
