Interested to Buy Any Domain ? << Click Here >> for more details...
I have oracle enterpaise stage, oracle bulkloader stage,
ODBC stage and I want to load data in to target, which of
the above stages do I need to use and why?
- 3 Answers
- 12920 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / vijaya
Hi
Its all depends on the source data if the data is coming
through oracle datastage then go for oracle enterprise stage
if it a incremental load but if it is initial load then go
for oracle bulkloader stage.Oracle enterprise is faster as
compare to ODBC.oracle enterprise runs parallel where as
ODBC runs seq.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Define Routines and their types?
What is the difference between validated and compiled in the datastage?
What is datastage engine?
Differentiate between operational datastage (ods) and data warehouse?
sed,awk,head
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Difference between server jobs & parallel jobs?
What is process model?
How to convert RGB Value to Hexadecimal values in datastage?
How do you schedule or monitoring the job?
What are the areas of application?
How can one find bugs in job sequence?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is data partitioning?
