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 the difference between constraind base load ordering and target load plan?

1119

How to add a number to a macro variable?

992

What is the difference between drill through and masterdetail reports?

1160

What is the difference between narmal load and bulk load?

1 1407

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

949

What is the use of tabular model, tabular sql, tabular reference in real time application?

959

How many types of facts and what are they?

1018

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1060

Why we use repository connectivity?

979

The same tier?

1056

What is recovering sessions?

936

How to define a cube??

928

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

1343

How to drill through from a powerplay cube to reportnet?

937

What is load manager?

1039

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the advantages of raid 1, 1/0, and

980

What are the different methods of loading dimension tables?

993

Explain what are the various methods of getting incremental records or delta records from the source systems?

967

What are the data types present in bo?

1127

How can we do data cleaning?

1055

What is the main difference between inmon and kimball philosophies of data warehousing?

1115

Describe the differences between a data warehouse and data mart.

1000

What is analytical or analytic mean?

1127

What is the goal of optimizer?

1049

What is drill-through?

985

Is union transormation is active transformation?

974

What is Active Datawarehousing?

1013

What are the stages of datawarehousing?

1013

What is dimension modeling?

1087

How can you implement many relations in star schema model?

1000

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