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 hide objects or columns?

Infotech,

6 11890

What is the user Object ? What is the need of it?

iGate, Infotech,

2 6585

How to sheduling the report ? What is the need of it?

Infotech,

2 5535

Can Bo generates the reports from cubical data ? Explain?

IBM,

2 6821

What is the difference between the Webintelligence and desktopintelligence?

IBM,

2 7780

What is the strategies ? what is the need of the strategies?

IBM,

2 6355

What is the merge dimension?

IBM,

3 8068

Can we do the slice and dice in webintellegence?

IBM,

5 26097

Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?

2 6752

It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?

HCL,

1 4882

What is the use of content store in cognos?

2 11560

What is the report extension in webi and deski

2 20671

Can we test the report other than manual testing?

2177

1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

2 5794

How to convert flat file into xml file? How to tune joiner?

Accenture,

2 11172

Un-Answered Questions { Data Warehouse }

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2929

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1260

r u done any partitions in ur project?

1827

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10400

what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

1092

What are prompted filters? Have you ever used them? Where?

986

What is Metrics designer?

1027

What are roles and groups and benefits of using them?

1057

How do you load first and last records into target table?

1159

I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2718

Which query language is used by amazon redshift?

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

1129

Explain and compare pros and cons of start schemas?

1065

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2427

Difference between PowerPlay transformer and power play reports?

2517

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