Answer Posted / manshul goel
FOR EACH is considered as a "group by" in the SQL generated
while when we apply FOR ALL it generates SUMMARY on the
basis of the element
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are aggregate transformation?
what are the major three types of modeling used?
Explain why denormalization is promoted in universe designing?
Where do we use semi and non additive facts?
Explain how to get the first 100 rows from the flat file into the target?
What is meta data and system catalog?
What are the various transformation available?
How do we design a universe?
Tell me what is degree of a relation?
Who needs data warehousing?
Explain why fact table is in normal form?
Explain what is the metadata extension?
What are session timeout and application timeout? Where we have to do this process?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is aggregate fact table?