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 the stages that are required in data warehousing?

1025

What are the steps involved in designing a fact table?

938

Explain etl?

1036

differentiate between two-tier, three-tier and four-tier connections.

1047

Explain true primary keys?

1055

What is an i-server?

1115

how do you create schema objects in 2 tier connection?

1017

Explain 4gt switch?

962

Explain md doctor?

1030

Explain object variable error?

1057

What are objects? Name different type of objects in microstrategy?

981

Name different type of objects in microstrategy?

971

What do you mean by trimming sql in microstrategy?

1112

Explain the various types of filters available.

1061

What are the different modes to run i-server?

1139

Un-Answered Questions { Data Warehouse }

How do you manage the Parameter files while migrating your data from one environment to another environment?

1071

What is data _null_?

1198

Your application mode has crashed. How would you run your i-server?

1051

Can we take backup when the database is opened?

1101

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1158

What is the difference between order and group variable in proc report?

1488

How can we increase the loading performance of oracle table in AbInitio?

1217

Why do you use Mapping Parameter and mapping variable?

1811

define galaxy repository in informatica

2295

What is VLDB?

1117

Explain the advantages of partitioned primary index in a query?

1079

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

1032

Is multi insert ansi standard?

2257

What is the purpose of having stored procedures in a database?

1225

how do u set partition points in the mapping?

2669

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