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

can BO generate reports with out CUBICAL data to repository?

4 12760

what is main functional differences between BO and COGNOs?

TCS,

5 17199

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

iGate,

6 17297

SAS System ?

5 12827

sas macros

TCS,

12 28825

how to test reports in businessobjects?

TCS,

8 54225

What is source qualifier?

2 10288

Difference between DSS & OLTP?

IBM,

6 51804

Explain grouped cross tab?

2631

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 19181

How many repositories can we create in Informatica?

Informatica,

14 29037

What is surrogate key?

IBM, Informatica,

5 22631

What is difference between Mapplet and reusable transformation?

UST,

3 7583

What is aggregate awareness?

2 8044

Explain reference cursor?

2170

Un-Answered Questions { Data Warehouse }

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

2063

How do you design a report which has multiple child datastream (horizontal seq)

2609

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

901

Differentiate between sessions and batches?

1022

How to create Target definition for flat files?

1229

What is bteq script in teradata?

1159

How are numeric and character missing values represented internally?

1662

What is metric store database?

1003

What are the different servers in sas? : sas-grid-administration

1059

Can you implement SCD2 using join, transformer and funnel stage?

1558

What does the trace option do?

1114

What do you mean by the overflow errors?

1371

How to test report in reportnet?

1013

What metadata importer can do in ab initio?

1221

What is the use of powerhouse?

1090

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