Answer Posted / hari
Hash partitioning
method is the key
based partition
method... And lookup
wich also compare and
retrieve the data
based on key
column... So by using
hash method wil
increase performance
in lookup...
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Define Routines and their types?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the main features of datastage?
What is the difference between orabulk and bcp stages?
How can we improve the performance in datastage?
What is a ds designer?
What is merge stage?
Give an idea of system variables.
client know skid info?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are stage variables and constants?
What are the job parameters?
What all the types of jobs you developed?
Name the different types of Lookups in Datastage?