Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14669 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
Notification Activity
Explain entity, attribute and relationship in datastage?
Differentiate between Join, Merge and Lookup stage?
What is the sortmerge collector?
What is datastage engine?
Define ds designer?
Can we use target hash file as a lookup ?
Explain ibm infosphere information server and highlight its main features?
What is the use of datastage designer?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the different common services in datastage?
How a source file is populated?
Explain Quality stage?
Differentiate between datastage and datastage tx?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
