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?
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 |
1)Source file contains one record, I want 100 records in target file.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How do u call shellscript/Batch file from DS?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
What is a merge?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
how to find no.of records in sequntial file itself?
What are the types of views in datastage director?
table actions available in oracle connector?