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

How to delete duplicate records in a flat file source?

2 8706

What is a configuration management?

1 4181

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

BirlaSoft,

2 6856

What is Drill by? drill through?

CMC, iFlex,

1 10734

How to test a cube?

2207

How to create predefined filters in B.O.

TCS,

2 11503

What is the difference between derived table and views? which one gives better performance?

TCS,

2 24954

when will use compatible and incompatible objects?

Business Intelligence Analytics, iGate, TCS,

1 8886

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13761

How to send duplicates to one target and unique rows to one target?target is empty

Amazon, IBM, Wipro,

9 31051

what is the difference between lookupoveride and joiner?

3 7863

what is plsql table?

2 6458

how to declare array in plsql?

1 9473

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

Cap Gemini, IBM,

4 18306

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2378

Un-Answered Questions { Data Warehouse }

What information is shared by the application across microstrategy web nodes?

1061

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

1022

What is the dense rank?

1242

What is a deadlock and how it occurs?

1177

What are the steps involved in the migration from older version to newer version of Informatica Server?

2121

What is the difference between snowflake and star schema?

1061

Explain what are the various methods of getting incremental records or delta records from the source systems?

981

difference between informatica 8.1.1 and 8.6

3687

What is difference between query studio and report studio?

1099

How a server job can be converted to a parallel job?

1105

What are the available primary index types in teradata.

1044

How can we schedule the graph in unix?

1009

What are the types of containers and how to create them?

993

What is merge stage?

1324

what are the special features in cognos reportnet?

1077

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