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?

975

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

945

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.

1008

Ist the schema that a data warehouse system can implements.

866

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

892

What is drill-through?

924

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

858

Store (and count) non-fact records?

863

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

872

Define data warehouse?

966

How to pivot row data using informatica?

876

Why null values are mapped as 0 in fact tables?

946

What are the differences between datamart vs. Reporting cube?

1032

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

925

List any five applications of data warehouse.

888

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

855

Difference between PowerPlay transformer and power play reports?

2476

What is critical column?

1111

What are the stages of datawarehousing?

951

What needs to be done while starting the database?

1049

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

933

What are parallel querys and query hints?

2177

What is execution plan?

1158

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

981

Explain dimension table ?

923

Explain what are fact, dimension, and measure?

933

Difference between cold fusion mx 6 and cold fusion mx 7?

799

what are the all possible features supported modify stage?

2061

What is a Decision Tree Algorithm?

4948

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

915

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