1. Cumulative Fact Table: This type of fact tables generally describes what was happened over the period of time. They contain additive facts. 2. Snapshot Fact Table: This type of fact table deals with the particular period of time. They contain nonadditive and semi-additive facts. Question.10
What is Grain of Fact?
Answer: The Grain of Fact is defined as the level at which the fact information is stored in a fact table. This is also called as Fact Granularity or Fact Event Level. Question.11
What is Factless Fact table?
Answer: The Fact Table which does not contains facts is called as Fact Table. Generally when we need to combine two data marts, then one data mart will have a fact less fact table and other one with common fact table. Question.12 Answer:
What are Measures?
Measures are numeric data based on columns in a fact table.
Question.13
What are Cubes?
Answer: Cubes are data processing units composed of fact tables and dimensions from the data warehouse. They provided multidimensional analysis. Question.14
What are Virtual Cubes?
Answer: These are combination of one or more real cubes and require no disk space to store them. They store only definition and not the data. Question.15
What is a Star schema design?
Answer: A Star schema is defined as a logical database design in which there will be a centrally located fact table which is surrounded by at least one or more dimension tables. This design is best suited for Data Warehouse or Data Mart. Question.16
What is Snow Flake schema Design?
Answer: In a Snow Flake design the dimension table (de-normalized table) will be further divided into one or more dimensions (normalized tables) to organize the information in a better structural format. To design snow flake we should first design star schema design. Question.17
What is Operational Data Store [ODS] ?
Answer: It is a collection of integrated databases designed to support operational monitoring. Unlike the OLTP databases, the data in the ODS are integrated, subject oriented and enterprise wide data. Question.18
What is Denormalization?
Answer: Denormalization means a table with multi duplicate key. The dimension table follows Denormalization method with the technique of surrogate key. Question.19
What is Surrogate Key?
Answer: A Surrogate Key is a sequence generated key which is assigned to be a primary key in the system (table).[/signinlocker] ETL TESTING INTERVIEW QUESTIONS AND ANSWERS (HTTP://LEARN.BIGCLASSES.COM/TAG/ETL-TESTING-INTERVIEW-QUESTIONS-ANDANSWERS) INFORMATICA INTERVIEW QUESTIONS AND ANSWERS (HTTP://LEARN.BIGCLASSES.COM/TAG/INFORMATICA-INTERVIEW-QUESTIONS-ANDANSWERS) MSBI INTERVIEW QUESTIONS AND ANSWERS (HTTP://LEARN.BIGCLASSES.COM/TAG/MSBI-INTERVIEW-QUESTIONS-AND-ANSWERS) ORACLE SQL QUESTIONS FOR DEVELOPERS (HTTP://LEARN.BIGCLASSES.COM/TAG/ORACLE-SQL-QUESTIONS-FOR-DEVELOPERS) QTP INTERVIEW QUESTIONS AND ANSWERS (HTTP://LEARN.BIGCLASSES.COM/TAG/QTP-INTERVIEW-QUESTIONS-AND-ANSWERS)
Previous: Loadrunner Interview Questions and answers (http://learn.bigclasses.com/loadrunner-interview-questions-andanswers) Next: Oracle DBA Interview Questions and answers (http://learn.bigclasses.com/oracle-dba-interview-questions-andanswers)
Leave a Reply Your Comment Here..
Name * Email * Website POST COMMENT
RSS (/feed)
|
Sitemap (/sitemap.xml)
(http://bigclasses.com/reviews/)
|
|
About Us (http://bigclasses.com/about-bigclasses.html)
Terms of Use (http://bigclasses.com/terms.html) policy.html)
