What is the difference between SQl Loader and OCI in datastage?
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 clean the datastage repository?
what are the devoleper roles in real time? plz tell i am new to datastage....
How many types of hash files are there?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Have you have ever worked in unix environment and why it is useful in datastage?
What is ds designer?
What is active and passive stage?
What are sequencers?
what is the use of surogate key in datastage
Lookup constraints
How to RD using transformer?
How many types of views are there in a datastage director?
What is merge stage?
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
Define meta stage?