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?

940

What is a general purpose scheduling tool?

1113

What is the metadata extension?

1000

What a static and local variable?

1077

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

1000

Explain what are the different methods of loading dimension tables?

953

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?

962

Explain what is full load & incremental or refresh load?

984

Explain what is the metadata extension?

1037

What are the main steps to build the data warehouse?

1119

Explain what is the difference between datawarehouse and bi?

969

What is scd1 , scd2 , scd3?

1084

Explain the difference between oltp and olap?

1123

What is a data warehousing?

1156

What is a fact table?

1 1634

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what are components of reportnet?

975

What are the different types of segments?

991

What is Cognos script editor?

2556

what type of raid setup would you put your tx logs?

940

What is surrogate key? Where we use it?

997

What are the stages of datawarehousing?

1013

Explain what is batch and describe about types of batches?

1080

What is critical column?

1183

Can a dimension table contain numeric values?

1058

What we will do with the universe for faster process?

982

What are vaious etl tools in the market?

1004

What is the 4 + 1 view model as it relates to system modeling?

1040

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1020

What are target types on the server?

995

What is vldb(very large databases)?

1013

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