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

explain about Prompt with example?

4 11970

What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

TCS,

2133

How do you test the reports? Explain the Unit testing procedures after developing the reports?

HP, TCS,

1 3422

How to apply securities for reports in cognos connection?

TCS,

2588

1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?

IBM,

4 9566

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

KPIT, TCS,

4 25243

how to do page breaks in cognos 8 Report studio pls give the navigation

4 16129

difference between join and union in reportstudio?

IBM,

2 14755

what is the difference between querystudio in reportnet and cognos8

CTS,

2194

When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

Wipro,

4 8226

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

IBM,

4 9046

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

TCS,

7 13889

what is the monster dimension plz give me one example

EDS,

2 9723

how to run 2 workflows sequentially. plz respond what is the process?

Cap Gemini, Target,

9 28807

Can u please describe the different types of traps with eg. Thanks

2 9430

Un-Answered Questions { Data Warehouse }

How can we use mapping variables in informatica? Where do we use them?

1296

How does hashing happens in teradata?

1150

What was the last computer book you purchased? Why?

2423

Mention a few design and development best practices for informatica?

1047

What are the various indexes in teradata? Why are they preferred?

1058

do you prefer proc report or proc tabulate? Why? : Sas programming

1035

What Proc glm does?

1147

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

2078

Explain the new features of teradata?

1094

how to implement scd2 in datastage 7.5 with lookup stage

5671

What are the programs that we can do with the microstrategy architect?

1100

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2091

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

1057

1. Explain your project.

2098

Explain about cumulative Sum or moving sum?

1096

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