Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is an error log table in informatica occurs and how to maintain it in mapping?

731

What is static and local variable?

737

What is the main difference between schema in rdbms and schemas in datawarehouse?

754

What is surrogate key? Where we use it explain with example?

653

Explain can a dimension table contains numeric values?

723

What is crass reference table?

790

What is a fact, dimension, measure?

752

Explain difference between e-r modeling and dimentional modeling?

738

Explain the definition of normalized and denormalized view and what are the differences between them?

694

Explain the definition of normalized and denormalized view?

683

Explain why fact table is in normal form?

700

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

706

Explain dimensional modelling?

709

What is batch processing?

769

What is aggregate fact table?

709


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is partitioning? What are the types of partitioning?

704


What is the metadata extension?

720


What is prompt types of prompts?use of prompts syntax of prompt?

866


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?

722


What is a Decision Tree Algorithm?

4736


Explain what is the data type of the surrogate key?

756


What is Discrete and Continuous data in Data mining world?

2318


What is the extension of file to save template?

743


Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

763


What is Cognos script editor?

2259


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?

709


What is factless fact tables?

792


Explain the difference between dw and bi?

704


What are the different types of scd's used in data warehousing?

903


How to performance tune reports?

754