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 |
what is meta data? Explain? Where it is used?
how can find maximum salary by using Remove duplicate stage?
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
What are the partition techniques available in your last project?
What is the use of surrogate key stage?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
how to identifie,is it innerjoin,leftouter join in lookup?