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
- 12967 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ravi kumar
oracle enterpaise stag is best becs we can use develope any
one.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the default padding character?
Name the different sorting methods in datastage.
How can we run same job in 1 day 2 times
What is the purpose of pivot stage and types of containers in datastage
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
What are the types of jobs we have in datastage?
How to enter a log in auditing table whenever a job get finished?
what is the use of materialized view?
How can we run same job in 1 day 2 times
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
Teradata 
