Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is difference between server jobs & parallel jobs?
Can you explain engine tier in information server?
What is the difference between datastage and informatica?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Differentiate between datastage and datastage tx?
Notification Activity
What is orabulk stage?
what is the use of materialized view?
How one source columns or rows to be loaded in to two different tables?
What are the different types of lookups in datastage?
How many types of sorting methods are available in datastage?
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.
Can you explain how could anyone drop the index before loading the data in target in datastage?
Differentiate between Join, Merge and Lookup stage?
