Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What are cubes and olap cubes?

985

What are the three tiers in etl?

1113

What are dimensions?

1059

What are the steps involved in etl process?

1026

What is initial load and what is full load?

986

Explain different types of partitioning?

1041

List few etl bugs?

942

What are three tier systems in etl?

1065

What are your responsibilities as an etl tester?

1158

What is grain of fact?

974

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

998

What do you understand by the term ‘transformation’?

1037

Explain the key challenges that you face while performing etl testing.

1009

Mention few test cases and explain them?

926

Explain etl mapping sheets?

1077

Un-Answered Questions { Data Warehouse }

table actions available in oracle connector?

1611

How you can run a graph infinitely in ab initio?

1585

How to stop/start redshift cluster?

What are the different problems that ?Data mining? can solve?

2830

Why is chameleon method used in data warehouse?

1165

name the function which is used to serialize the ti process?

Compare microstrategy and tableau.

985

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1834

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2524

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

1031

Clarify the utilization of aggregator cache record?

1000

Explain clustering algorithm?

2270

On which Dimension Table you implemented SCD Type in your Project

2042

What does refresh system mean, and what are its distinctive choice?

1179

What is the order of application for output data set options, input data set options and SAS statements?

1561

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