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 is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain a linked cube?
Explain what is type 2 version dimension?
Can you state some of the innovations throughout history?
What is surrogate key? Where we use it? Explain with examples.
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
how much memory space occupied real time project (roughly)?
What a static and local variable?
Tell me what is full load & incremental or refresh load?
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 meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Which component has onread method and what it is used for?
What is drilling across?
What is meta data and system catalog?
Explain what is batch and describe about types of batches?
Explain what are the steps to build the data warehouse?