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

which r the connectors used in san?

2189

what is the generated prompt,how can i use?

5 19827

how much memory space occupied real time project (roughly)?

2228

What is mean by tuning the report?

1 3275

what are they different types of report in BO?

6 32345

How do scheduling the report in BO XIR2? can you say what are they steps?

5 11932

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 27136

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 9556

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

BirlaSoft,

5 15262

What are set operators in Oracle

Deloitte, Wipro,

3 17134

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

Deloitte,

9 19317

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

Deloitte,

21 40100

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 10754

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 5132

What is Target Update Override? What is the Use ?

Patni,

8 19851

Un-Answered Questions { Data Warehouse }

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1020

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1067

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3844

What are the types of dimensional modeling?

1067

List out teradata data types?

1018

what are logical views used for?

1015

What can you learn from the SAS log when debugging?

1392

Implementation methodology

1720

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4324

What are Dimensional table?

1064

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

1171

Explain bus schema?

981

What are configuration objects?

1063

How to a create header dynamically in a crosstab report in cognos 8.1?

2441

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1814

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