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 are the steps of implementing data warehousing?

1045

Explain about core dimension, balanced dimension, and dirty dimension?

1009

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1077

Ist the schema that a data warehouse system can implements.

941

What is the very basic difference between data warehouse and operational databases?

966

What is drill-through?

988

How to pivot data using informatica when you have variable amount of pivot rows?

904

Store (and count) non-fact records?

933

What is many-to-many dimensional model in datawarehousing ?

936

Define data warehouse?

1042

How to pivot row data using informatica?

958

Why null values are mapped as 0 in fact tables?

1004

What are the differences between datamart vs. Reporting cube?

1097

What should I have in mind when building olap solution from scratch?

983

List any five applications of data warehouse.

939

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the different types of segments?

991

How to generate iqd file from framework manager?

961

What are the tools available for etl?

972

Code the tables statement to produce a multi-level frequency?

1009

What is data type of the surrogate key?

1001

What is the difference between mapping parameter & mapping variable in data warehousing?

987

What is the very basic difference between data warehouse and operational databases?

966

How to create context?

1011

Explain why fact table is in normal form?

970

What are session timeout and application timeout?

1018

What are components of report studio?

1055

What we will do with the universe for faster process?

982

What is crass reference table?

1054

What are the different problems that ?Data mining? can solve?

2831

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

904

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