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
- 13060 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
How to Remove Duplicate using SQL?
What is the difference between informatica and datastage?
Notification Activity
What are the types of containers and how to create them?
What are the functionalities of link collector?
Why we use surrogate key?
Define Merge?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is aggtorec restructure operator?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Difference between ‘validated ok’ and ‘compiled’ in data stage?
how to abort the job its matain duplicates?
