Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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?

969

What is static and local variable?

1041

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

1093

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

932

Explain can a dimension table contains numeric values?

971

What is crass reference table?

1061

What is a fact, dimension, measure?

1212

Explain difference between e-r modeling and dimentional modeling?

994

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

932

Explain the definition of normalized and denormalized view?

903

Explain why fact table is in normal form?

976

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

996

Explain dimensional modelling?

985

What is batch processing?

1038

What is aggregate fact table?

996

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the goal of optimizer?

1049

Explain how to get the first 100 rows from the flat file into the target?

976

How can we do data cleaning?

1067

Why fact table is in a normal form?

997

Explain what are slowly changing dimensions?

1029

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2471

What is VLDB?

1072

what is parallel query?

2092

What is mean by aggregate aware?

1096

How to reduce warnings?

945

What is Cognos script editor?

2563

What is a hash cluster?

990

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2052

What is the advantages data mining over traditional approaches?

969

Explain what is a cube in data warehousing concept?

988

For More Un-Answered { Data Warehouse General } Questions Click Here