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

what is the difference between bo and cognos?

1 4542

Can i merge two dataproviders if they do not have common column?

3 8109

1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?

Virtusa,

1 8398

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

Mphasis,

4 11959

how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?

4 6945

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4406

when u face critical situation in ur project, how to solve them?

Toyota,

1 10217

what is surrogate key give example?

2 6412

what is sdibling function tell me the some functions

IBM,

3 6966

i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.

IBM,

2 5596

what is the core universe and what is the active universe?

1 5075

What is the prm file ? can anybody explain me ?

2 7374

what is the difference b/w the refresh and buffered data?

2342

What is the need of live office connector

3 7463

What is mean by stored procedure ? and how we can generate stored procedure universe?

3 5127

Un-Answered Questions { Data Warehouse }

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1983

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

954

Explain about enterprise scalability and roi of data integration suite?

878

What is drilling across?

992

Is it possible to use a client with different version than that of its Informatica server?

1141

Name a few sectors which use data warehousing?

927

Explain the use of proc gplot? : sas-grid-administration

986

Explain direct and indirect flat file loading (source file type) - informatica

1318

The same tier?

1056

What are the ways in which macro variables can be created in sas programming?

1103

What do you mean by tpt in teradata?

1021

Where we use surrogate key explain with example?

1126

Give some ways by which you can define the variables to produce the summary report (using proc report)?

1089

How do you delete duplicate observations in sas?

1072

Can a record be inserted and updated in database using microstartegy?

930

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