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 8684

What is a configuration management?

1 4163

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

BirlaSoft,

2 6824

What is Drill by? drill through?

CMC, iFlex,

1 10719

How to test a cube?

2192

How to create predefined filters in B.O.

TCS,

2 11470

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

TCS,

2 24931

when will use compatible and incompatible objects?

Business Intelligence Analytics, iGate, TCS,

1 8871

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13737

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

Amazon, IBM, Wipro,

9 30990

what is the difference between lookupoveride and joiner?

3 7837

what is plsql table?

2 6437

how to declare array in plsql?

1 9460

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

Cap Gemini, IBM,

4 18259

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

2365

Un-Answered Questions { Data Warehouse }

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2186

What is the purpose of Dataware Control?

1048

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

999

Explain how to get the first 100 rows from the flat file into the target?

968

U r project in which stage in implementation?

2516

What are various warehousing tools?

1003

What are the various indexes in teradata?

1049

What are the job parameters?

1221

What is a logical size of a table and what does it depend on?

967

What are the different types of variables in obiee 11g? Explain

965

Explain parsing engine in teradata?

1090

What are the special input delimiters used in SAS?

1183

Why need staging area database for dwh?

1080

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1085

How can we store previous session logs?

1080

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