Answer Posted / guest
A hash partition is used to ensure even distribution of
data among pre determined number of partitions. It has to
be called explicitly by addressing column Partition by
Hash.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What according to you might be the future of data warehousing?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is the function of etl when used in data warehousing?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is hybrid slowly changing dimension?
I need to set predefined condition. How I do this?
Code the tables statement to produce a multi-level frequency?
Is there any difference in testing database and data ware housing?
How to provide security in frame work manager for a query subject?
What is index awareness in universe?
Explain difference between data ware house & data mart?
Explain where do we use semi and non additive facts?
What are the advantages of raid 1, 1/0, and