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 Active Datawarehousing?

970

What is the difference between Datawarehouse and OLAP?

901

What is called data cleaning?

1172

What is factless fact tables?

1147

What is the difference between metadata and data dictionary?

1085

What are the tools available for etl?

940

What is the goal of optimizer?

1018

What are the different types of datawarehosuing?

967

What are the approaches used by optimizer during execution plan?

866

What needs to be done while starting the database?

1063

What is the definition of cube in datawarehousing?

958

What is the difference between er modeling and dimensional modeling?

1092

What is defined as partial backup?

1042

What are the stages of datawarehousing?

971

What is called dimensional modelling?

1052

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

923

What are the design methods of data warehousing?

907

Tell me what is full load & incremental or refresh load?

908

What is drilling across?

943

Explain piconet?

913

What is Analysis Services?

2084

What is real-time datawarehousing?

981

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

1203

What is the limit to the number of sources and targets you can have in a mapping?

1072

Explain which columns go to the fact table and which columns go the dimension table?

884

What is normalization, first normal form, second normal form, third normal form?

926

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5942

What do you mean by static and local variable?

923

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1007

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

945

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