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 type of raid setup would you put your tx logs?

886

What is a general purpose scheduling tool?

1024

What is the metadata extension?

929

What a static and local variable?

1018

Explain when do we analyze the tables? How do we do it?

938

Explain what are the different methods of loading dimension tables?

902

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?

920

Explain what is full load & incremental or refresh load?

936

Explain what is the metadata extension?

980

What are the main steps to build the data warehouse?

1051

Explain what is the difference between datawarehouse and bi?

905

What is scd1 , scd2 , scd3?

1034

Explain the difference between oltp and olap?

1055

What is a data warehousing?

1065

What is a fact table?

1 1519

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is the difference between datawarehouse and bi?

905

What does level of granularity of a fact table signify?

1040

What is Cognos script editor?

2482

Explain a linked cube?

907

Explain why dimenstion tables are denormalized in nature?

875

What function should we use to display the value entered or selected by a user in response to a prompt?

922

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

1179

What are the types of SCD?

1092

Could any one explain me how to create cascading prompts?

988

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

895

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

921

What is cubes?

1001

What is dimension modeling?

979

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

963

What is mean by aggregate aware?

987

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