1. Explain the situations where snowflake is better than star schema
2. How do you connect two fact tables ? Is it possible ?
3. explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dim explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions.
4. What are the vaious ETL tools in the Market
5. What is ETL
6. Explain ODS and ODS types.
7. can you convert a snowflake schema in to star schema?
9. what is the datatype of the surrgate key
10. What is the difference between Data modelling and Dimensional modelling?
11. What is meant by Aggregate Factable?
12. what is the main FUNCTIONAL difference between ROLAP,MOLAP,HOLAP?
13. can a dimension table contains numeric values? Subscribe
14. what is BUS Schema? Subscribe
15. 1.what is incremental loading?2.what is batch processing?3.what is cross reference table?4.what is
1.what is incremental loading?2.what is batch processing?3.what is cross reference table?4.what is aggregate fact table Subscribe
16. What is ER Diagram
17. Do u need seperate space for Datawarehouse & Data mart Subscribe
18. What are conformed dimensions Subscribe
19. Explain Bill Inmon's versus Ralph Kimball's Approach to Data Warehousing.
20. Is it correct/feasible develop a Data Mart using an ODS?
21. What is the Difference between OLTP and OLAP
22. What are the various techniques in ER modelling?
23. What is the business rule for writing the requirement?
24. How do you load the data conditionally by run steps ?
25. What Snow Flake Schema
26. Why are OLTP database designs not generally a good idea for a Data Warehouse
27. What are Data Marts
28. What is a Data Warehousing?
29. what are the different architecture of datawarehouse
30. what is the life cycle of data warehouse projects
31. What is a CUBE in datawarehousing concept? Subscribe
32. What are late arriving Facts and late arriving dim ? How does it impacts DW?
33. What is Dimensional Modelling
34. For 80GB Datawarehouse How many records are there in Fact Table There are 25 Dimension and 12 Fa For 80GB Datawarehouse How many records are there in Fact Table There are 25 Dimension and 12 Fact Tables
35. What is hybrid slowly changing dimension
36. What is ODS
37. What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tab What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables
38. What are slowly changing dimensions
39. What are non-additive facts
40. what is rapidly changing dimension?
41. What are the various Reporting tools in the Market
42. What is a dimension table
43. What is the purpose of "Factless Fact Table"? How it is involved in Many to many relation What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?
44. What type of Indexing mechanism do we need to use for a typical datawarehouse
45. What is Fact table Subscribe
46. What are modeling tools available in the Market
47. What is SCD1 , SCD2 , SCD3
48. What is a Star Schema
49. What is Data warehosuing Hierarchy?
50. What are the possible data marts in Retail sales.?
51. What is slicing and dicing? Explain with real time usage and business reasons of it's use
52. What is the role of surrogate keys in data warehouse and how will u generate them?
53. what is junk dimension?what is the difference between junk dimension and degenerated dimension?
54. i want to know how to protect my data over networ.which software will be use
55. Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is bette
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?
56. What is source qualifier?
57. why fact table is in normal form?
58. Explain degenerated dimension in detail.
59. what are the various attributes in time dimension, If this dimension has to consider only date of what are the various attributes in time dimension, If this dimension has to consider only date of birth of a citizen of a country?
2. How do you connect two fact tables ? Is it possible ?
3. explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dim explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions.
4. What are the vaious ETL tools in the Market
5. What is ETL
6. Explain ODS and ODS types.
7. can you convert a snowflake schema in to star schema?
9. what is the datatype of the surrgate key
10. What is the difference between Data modelling and Dimensional modelling?
11. What is meant by Aggregate Factable?
12. what is the main FUNCTIONAL difference between ROLAP,MOLAP,HOLAP?
13. can a dimension table contains numeric values? Subscribe
14. what is BUS Schema? Subscribe
15. 1.what is incremental loading?2.what is batch processing?3.what is cross reference table?4.what is
1.what is incremental loading?2.what is batch processing?3.what is cross reference table?4.what is aggregate fact table Subscribe
16. What is ER Diagram
17. Do u need seperate space for Datawarehouse & Data mart Subscribe
18. What are conformed dimensions Subscribe
19. Explain Bill Inmon's versus Ralph Kimball's Approach to Data Warehousing.
20. Is it correct/feasible develop a Data Mart using an ODS?
21. What is the Difference between OLTP and OLAP
22. What are the various techniques in ER modelling?
23. What is the business rule for writing the requirement?
24. How do you load the data conditionally by run steps ?
25. What Snow Flake Schema
26. Why are OLTP database designs not generally a good idea for a Data Warehouse
27. What are Data Marts
28. What is a Data Warehousing?
29. what are the different architecture of datawarehouse
30. what is the life cycle of data warehouse projects
31. What is a CUBE in datawarehousing concept? Subscribe
32. What are late arriving Facts and late arriving dim ? How does it impacts DW?
33. What is Dimensional Modelling
34. For 80GB Datawarehouse How many records are there in Fact Table There are 25 Dimension and 12 Fa For 80GB Datawarehouse How many records are there in Fact Table There are 25 Dimension and 12 Fact Tables
35. What is hybrid slowly changing dimension
36. What is ODS
37. What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tab What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables
38. What are slowly changing dimensions
39. What are non-additive facts
40. what is rapidly changing dimension?
41. What are the various Reporting tools in the Market
42. What is a dimension table
43. What is the purpose of "Factless Fact Table"? How it is involved in Many to many relation What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?
44. What type of Indexing mechanism do we need to use for a typical datawarehouse
45. What is Fact table Subscribe
46. What are modeling tools available in the Market
47. What is SCD1 , SCD2 , SCD3
48. What is a Star Schema
49. What is Data warehosuing Hierarchy?
50. What are the possible data marts in Retail sales.?
51. What is slicing and dicing? Explain with real time usage and business reasons of it's use
52. What is the role of surrogate keys in data warehouse and how will u generate them?
53. what is junk dimension?what is the difference between junk dimension and degenerated dimension?
54. i want to know how to protect my data over networ.which software will be use
55. Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is bette
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?
56. What is source qualifier?
57. why fact table is in normal form?
58. Explain degenerated dimension in detail.
59. what are the various attributes in time dimension, If this dimension has to consider only date of what are the various attributes in time dimension, If this dimension has to consider only date of birth of a citizen of a country?
60. What is difference between BO, Microstrategy and Cognos
61. how data in datawarehouse stored after data has been extracted and transformed from hetrogeneous sources and where does the data go from datawarehouse.
62. what is the difference between star schema and snow flake schema ?and when we use those schema's?
63. what is the difference between Datawarehouse and Datawarehousing
64. what is data cleaning?
65. How do you load the time dimension
66. What are the Different methods of loading Dimension tables
67. What is Difference between E-R Modeling and Dimentional Modeling.
68. what is the need of surrogate key;why primary key not used as surrogate key
69. What is a linked cube?
70. What is surrogate key ? where we use it expalin with examples
71. Summarize the differene between OLTP,ODS AND DATA WAREHOUSE ?
72. what is cube and why we are crating a cube what is diff between etl and olap cubes any budy a what is cube and why we are crating a cube what is diff between etl and olap cubes any budy ans plz?
73. what is conformed fact?
74. What is meant by metadata in context of a Datawarehouse and how it is important?
75. which automation tool is used in data warehouse testing?
76. what is the differences between the static and dynamic caches?
77. What is a lookup table
78. what are the steps to build the datawarehouse
79. what is the definition of normalized and denormalized view and what are the differences between the what is the definition of normalized and denormalized view and what are the differences between them
Datawarehousing Analysis Services Interview Questions
61. how data in datawarehouse stored after data has been extracted and transformed from hetrogeneous sources and where does the data go from datawarehouse.
62. what is the difference between star schema and snow flake schema ?and when we use those schema's?
63. what is the difference between Datawarehouse and Datawarehousing
64. what is data cleaning?
65. How do you load the time dimension
66. What are the Different methods of loading Dimension tables
67. What is Difference between E-R Modeling and Dimentional Modeling.
68. what is the need of surrogate key;why primary key not used as surrogate key
69. What is a linked cube?
70. What is surrogate key ? where we use it expalin with examples
71. Summarize the differene between OLTP,ODS AND DATA WAREHOUSE ?
72. what is cube and why we are crating a cube what is diff between etl and olap cubes any budy a what is cube and why we are crating a cube what is diff between etl and olap cubes any budy ans plz?
73. what is conformed fact?
74. What is meant by metadata in context of a Datawarehouse and how it is important?
75. which automation tool is used in data warehouse testing?
76. what is the differences between the static and dynamic caches?
77. What is a lookup table
78. what are the steps to build the datawarehouse
79. what is the definition of normalized and denormalized view and what are the differences between the what is the definition of normalized and denormalized view and what are the differences between them
Datawarehousing Analysis Services Interview Questions
1. What are the main important differences between olap and oltp
2. Discus two reasons why feeding data into OLAP system directly from the source operational system is not recommended
3. Which are the OLAP tools available that are supported by Oracle?
4. What is the difference between analysis and synthesis?
5. What are the tools used for data analysis in DHW especially where Data Stage is being used as the ETL tool?
6. I am loaded with questions as I am an experienced ETL coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of NON EMPTY so that I don't see r
7. What is the Service name for Microsoft SQL Server Analysis Services 2000?
9.What is the difference between Business Requirement Document and Use case Document. What is the difference. I need a good BRD and UC template.
10.What is Data Warehouse
2. Discus two reasons why feeding data into OLAP system directly from the source operational system is not recommended
3. Which are the OLAP tools available that are supported by Oracle?
4. What is the difference between analysis and synthesis?
5. What are the tools used for data analysis in DHW especially where Data Stage is being used as the ETL tool?
6. I am loaded with questions as I am an experienced ETL coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of NON EMPTY so that I don't see r
7. What is the Service name for Microsoft SQL Server Analysis Services 2000?
9.What is the difference between Business Requirement Document and Use case Document. What is the difference. I need a good BRD and UC template.
10.What is Data Warehouse
No comments:
Post a Comment