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 11971

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,

2134

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

HP, TCS,

1 3425

How to apply securities for reports in cognos connection?

TCS,

2590

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 9568

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

KPIT, TCS,

4 25245

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 14757

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 9048

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

TCS,

7 13891

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 28810

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

2 9430

Un-Answered Questions { Data Warehouse }

it will become easy if uuu provide website linkssss and list of consultanciessssss

2030

How many bi services node can be clustered together?

925

What is olap (on-line analytical processing?

1112

What is etl process. How many steps etl contains explain with example?

1004

Tell me about Dnamic and Static Dashboards?

2406

List some pros and cons of amazon redshift?

After the complete generation of a report who will test the report and who will analyze it?

1044

Explain clustering?

1033

How do you see a ddl for an existing table?

1063

List out some of the air commands used in abintio?

1434

How will you solve the problem that occurs during update?

1111

What is DR strategy for Informatica project?

1230

What are the fundamental blocks of co> operating system of ab initio?

1313

What is a dw? Why do we need it?

1032

what is user variable in affinium campaign? and some real time examples.

4234

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