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 a folder? Difference types of stages?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Define ds designer?
Nls stands for what in datastage?
What is apt_config in datastage?
How to reverse the string using unix?
What a datastage macro?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How can one find bugs in job sequence?
What is the command line function to import and export the ds jobs?
in oracle target stage when we use load option and when we use upsert option?
How to convert RGB Value to Hexadecimal values in datastage?
What is oci?
how to implement scd2 in datastage 7.5 with lookup stage
what is repositery?
