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 7609

what is universe testing(not mention check integrity)

1 5172

in xir2 how to send reports to end user

TCS,

2 7247

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 9536

how we improve the performance of report and universe?

Accenture, IBM,

4 15548

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 9170

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 13390

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

IBM, TCS,

2 15417

can a port in expression transf be given the name DISTINCT

3 13697

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,

1 2164

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 10035

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

3 10401

what is the difference between aggregation and roll up aggregation?

1 7144

Difference between cognos report net and cognos8

1 6755

Difference betwween cognos report net architecture and cognos8 architecture

3 12970

Un-Answered Questions { Data Warehouse }

How do you remove duplicate records in informatica? And how many ways are there to do it?

1233

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1197

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

What sort of existing documents should business analysts refer to when starting on a new project?

1078

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

Write the unconnected lookup syntax?

1148

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2437

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8286

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1177

how many reports have u created ? explain a few.

2160

What is aggregate table and aggregate fact table ... Any examples of both?

1118

How to add default rules in transformer?

1284

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