Explain the definition of normalized and denormalized view and what are the differences between them?
694What are situations where snow flake schema is better than star schema to use and when the opposite is true?
706Post New Data Warehouse General Questions
Explain what is partitioning? What are the types of partitioning?
What is the metadata extension?
What is prompt types of prompts?use of prompts syntax of prompt?
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?
What is a Decision Tree Algorithm?
Explain what is the data type of the surrogate key?
What is Discrete and Continuous data in Data mining world?
What is the extension of file to save template?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is Cognos script editor?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is factless fact tables?
Explain the difference between dw and bi?
What are the different types of scd's used in data warehousing?
How to performance tune reports?