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 is drill-through?

1047

How to pivot data using informatica when you have variable amount of pivot rows?

959

Store (and count) non-fact records?

989

What is many-to-many dimensional model in datawarehousing ?

992

Define data warehouse?

1105

How to pivot row data using informatica?

1020

Why null values are mapped as 0 in fact tables?

1050

What are the differences between datamart vs. Reporting cube?

1165

What should I have in mind when building olap solution from scratch?

1061

List any five applications of data warehouse.

991

How can we run the graph?

1135

In a star schema, are foreign key constraints between facts and dimensions neccessary?

1043

Fact table is in normalized or de-normalized form?

1031

How can we do data cleaning?

1106

what is the difference between floor and ceil functions in sas? : Sas-administrator

1324

Un-Answered Questions { Data Warehouse }

can u give example for factless fact table

6788

what is data modeling?

2360

is there any difference between operational database and data base?if yes what r they?

2121

What is the commit type if you have a transaction control transformation in the mapping?

1100

how many types of dimensions are available in informatica?

1189

faq's on cognos

4100

Different circumstance which drives informatica server to expel records?

1047

How to a create header dynamically in a crosstab report in cognos 8.1?

2488

What is rank transform?

1061

Can you explain the process of calendar?

1162

How do you call a store procedure within a transformation?

1055

Explain sql transformation in script mode examples in informatica

1213

Identifying the bottlenecks in various components of Informatica and resolving them.

1983

What is a linked cube?

1053

Informatica settings are available in which file?

1049

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