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 12594

what is main functional differences between BO and COGNOs?

TCS,

5 17064

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

iGate,

6 17101

SAS System ?

5 12630

sas macros

TCS,

12 28428

how to test reports in businessobjects?

TCS,

8 53951

What is source qualifier?

2 10181

Difference between DSS & OLTP?

IBM,

6 51559

Explain grouped cross tab?

2585

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 19054

How many repositories can we create in Informatica?

Informatica,

14 28666

What is surrogate key?

IBM, Informatica,

5 22455

What is difference between Mapplet and reusable transformation?

UST,

3 7440

What is aggregate awareness?

2 7930

Explain reference cursor?

2132

Un-Answered Questions { Data Warehouse }

Explain about a time when you discovered a more efficient way to do a work task?

1104

What are the design methods of data warehousing?

907

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1060

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2690

What is the difference between Open Connection command ang Open Session Command?

2401

What are global filter and how they differ from column filter?

909

How can we run the graph? How can we schedule the graph in unix?

907

Explain transformations?

979

What is SAS informats?

1075

what is the use of sas management console? : Sas-di

1056

Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.

976

What is a three-tier data warehouse?

1071

What is conformed fact?

1054

Explain why we use partitioning the session in informatica?

1035

Highlight the main features of datastage?

1113

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