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 critical column?

1259

What is "method/1"?

1151

Explain the difference between data ware house & data mart?

1022

After the complete generation of a report who will test the report and who will analyze it?

1038

What is the difference between snowflake and star schema?

1097

Explain the importance of data warehouse?

1062

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

992

What is a source qualifier?

1156

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

1020

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

959

What is difference between e-r modeling and dimensional modeling?

970

What is a hash cluster?

1042

What is data analysis? Where it will be used?

1043

What are the methodologies of data warehousing?

1036

What is the difference between dependent data warehouse and independent data warehouse?

1055

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

ware house management system is used?

1055

How to create prompts in report net?

1040

explain about dirty dimension?

1240

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

1030

How can you clear the cache?

1057

What are the types of partitioning?

1079

What is data analysis?

1003

Explain where do we use semi and non additive facts?

1063

What are the advantages of query studio compared to report studio?

943

Explain the hierarchies level data warehousing.

933

What are the different methods of loading dimension tables?

1042

What is pre-emptive and non-pre-emptive?

1028

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

1046

What is freehand sql?

1097

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

971

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