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 4164

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

BirlaSoft,

2 6824

What is Drill by? drill through?

CMC, iFlex,

1 10720

How to test a cube?

2192

How to create predefined filters in B.O.

TCS,

2 11471

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

TCS,

2 24932

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 6440

how to declare array in plsql?

1 9461

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 }

Have you worked with/created Parameter file

1664

How one source columns or rows to be loaded in to two different tables?

1130

what is catalog and types of catalogs in cagnos and which is better?

1159

Fact table is in normalized or de-normalized form?

962

If a Node is busy what are the steps you can take to avoid ?

2414

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

What is the metric store database?

970

What are the job parameters?

1221

what are factless facts? And in which scenario will you use such kinds of fact tables.

1808

what is an ETL or ETT? And what are the different types?

7495

What dedup-component and replicate component does?

1274

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1083

Does redshift support unstructured data?

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1195

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

1032

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