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

Explain meta data?

1043

Explain why are oltp database designs not generally a good idea for a data warehouse?

1041

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

959

Explain is olap databases are called decision support system true/false?

1016

How can we determine what records to extract?

1091

What is a staging area? Do we need it? What is the purpose of a staging area?

1005

Explain which are the olap tools available that are supported by oracle?

1020

Explain some of modeling tools available in the market?

977

Explain what are non-additive facts?

1043

Explain what is the difference between power center & power mart?

1012

Explain if a flat file cotains 1000 records how can I get first and last records only?

940

Explain what is fact less fact table? Where you have used it in your project?

942

What does level of granularity of a fact table signify?

1107

What are the different methods of loading dimension tables?

1000

Explain what are the modules in power mart?

1060

Un-Answered Questions { Data Warehouse }

what is the main advantage of impromptu over cognos reportnet?

1052

what is function of retain statment

2049

What’s the use AWS redshift cluster Service?

For which purpose Redshift is used for ?

What is a folder? Difference types of stages?

1187

What do you mean by trimming sql in microstrategy?

1054

How do you promote a non-reusable transformation to reusable transformation?

1144

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2280

Plz can any one say me how to get the informatica certification materials and dumps

2059

What all the types of jobs you developed?

1191

Name the types of transformation?

964

What are the types of hashed files in data stage

1119

Explain clustering?

985

how can you import .csv file in to sas? : Sas programming

1114

What is data transformation manager process?

1173

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