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 we send repotrts/documents to end user

HP,

2 7495

what is universe testing(not mention check integrity)

1 5075

in xir2 how to send reports to end user

TCS,

2 7132

How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD?

TCS,

2 9415

how we improve the performance of report and universe?

Accenture, IBM,

4 15384

I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?

Keane India Ltd,

4 9014

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

Cap Gemini, IBM,

5 13227

What is ment by For each For all function. In which case we use the option in BO?

IBM, TCS,

2 15317

can a port in expression transf be given the name DISTINCT

3 13573

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

HCL,

2111

In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 9863

What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?

3 10257

what is the difference between aggregation and roll up aggregation?

1 7078

Difference between cognos report net and cognos8

1 6663

Difference betwween cognos report net architecture and cognos8 architecture

3 12804

Un-Answered Questions { Data Warehouse }

Why should you put your data warehouse on a different system than your oltp system?

991

Do we need an ETL tool? When do we go for the tools in the market?

986

How to open an older version of an object in the workspace?

1217

What is called materialized view?

1087

How can one find bugs in job sequence?

1436

Explain lookup transformation in informatica

1089

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1020

What is rank transformation?

1000

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1173

What is many-to-many dimensional model in datawarehousing ?

953

What are session timeout and application timeout?

1034

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1274

Explain about core dimension,

999

--------------Explain Table of contents?

2036

How can create users and permissions in cognos?

975

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