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 12501

what is main functional differences between BO and COGNOs?

TCS,

5 16958

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

iGate,

6 17002

SAS System ?

5 12540

sas macros

TCS,

12 28259

how to test reports in businessobjects?

TCS,

8 53811

What is source qualifier?

2 10114

Difference between DSS & OLTP?

IBM,

6 51447

Explain grouped cross tab?

2565

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 19008

How many repositories can we create in Informatica?

Informatica,

14 28471

What is surrogate key?

IBM, Informatica,

5 22367

What is difference between Mapplet and reusable transformation?

UST,

3 7376

What is aggregate awareness?

2 7883

Explain reference cursor?

2109

Un-Answered Questions { Data Warehouse }

Explain the different kinds of facts.

933

What is upsert statement in teradata?

1051

What is the advantages data mining over traditional approaches?

904

What are cognos connection initial page components?

1052

Explain the importance of data warehouse?

940

Explain the Roles in mstr?

910

what is the use of catlog or catlogfile?

2295

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2171

what are the day to day activities of teradata DBA ?

5755

what is operational data and operational system? : Sas-di

1055

Describe the between keyword in teradata?

979

Tell me about Dnamic and Static Dashboards?

2270

name several ways to achieve efficiency in your program? : Sas programming

984

Which transformation is needed while using the Cobol sources as source definitions?

1123

what is an use case?

984

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