Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14695 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
Define repository tables in datastage?
What can we do with datastage director?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
how to implement scd2 in datastage 7.5 with lookup stage
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the different type of jobs in datastage?
Can you explain tagbatch restructure operator?
How do you run datastage job from the command line?
in oracle target stage when we use load option and when we use upsert option?
How do y read Sequential file from job control?
If you want to use a same piece of code in different jobs, how will you achieve this?
Explain datastage architecture?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Why do you need stage variables?
