Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14849 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
what is the difference between == and eq in UNIX shell scripting?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the difference between orabulk and bcp stages?
What all the types of jobs you developed?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is orabulk stage?
What are the various kinds of the hash file?
what is repositery?
What is job control?
What are the different options associated with dsjob command?
What is the difference between in process and inter process?
Explain connectivity between datastage with datasources?
How can one find bugs in job sequence?
Which warehouse using in your datawarehouse
What is a quality stage in datastage tool?
