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
Can we take backup when the database is opened?
Explain what does level of granularity of a fact table signify?
List down some of the real time data-warehousing tools?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What is normalization, first normal form, second normal form, third normal form?
What is dimension modeling?
What are the data types present in bo?
Explain me what is vldb?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What are the steps involved in designing a fact table?
Explain what are the modules in power mart?
How to performance tune reports?
What is many-to-many dimensional model in datawarehousing ?
Explain swot analysis?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?