|
Question |
Rating |
View Answer |
|
What is junk dimension? What are junk dimension and degenerated dimension?
|
|
View Answer |
|
What is Data warehousing Hierarchy?
|
|
View Answer |
|
What is a look up table? |
|
View Answer |
|
What is a CUBE in data warehousing concept? |
|
View Answer |
|
How are the Dimension tables designed? |
|
View Answer |
|
Is it correct/feasible develop a Data Mart using an ODS? |
|
View Answer |
|
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ? |
|
View Answer |
|
What is ODS? |
|
View Answer |
|
Why should you put your data warehouse on a different system than your OLTP system? |
|
View Answer |
|
Why is Data Modeling Important? |
|
View Answer |
|
What is ETL? |
|
View Answer |
|
What does level of Granularity of a fact table signify? |
|
View Answer |
|
What is SCD1 , SCD2 , SCD3? |
|
View Answer |
|
Why are OLTP database designs not generally a good idea for a Data Warehouse? |
|
View Answer |
|
What are the various Reporting tools in the Market? |
|
View Answer |
|
What are conformed dimensions? |
|
View Answer |
|
What are the Different methods of loading Dimension tables? |
|
View Answer |
|
What is conformed fact? |
|
View Answer |
|
What are non-additive facts? |
|
View Answer |
|
What type of Indexing mechanism do we need to use for a typical data warehouse? |
|
View Answer |