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?

2233

what is the generated prompt,how can i use?

5 19983

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

2289

What is mean by tuning the report?

1 3369

what are they different types of report in BO?

6 32549

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

5 12098

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

5 27289

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 9695

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 15427

What are set operators in Oracle

Deloitte, Wipro,

3 17230

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 19588

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 40730

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 10826

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

1 5215

What is Target Update Override? What is the Use ?

Patni,

8 20080

Un-Answered Questions { Data Warehouse }

What are the various ways of incorporating security in microstrategy?

1053

What is a pre-defined event and user-defined event?

1086

What are the types of jobs we have in datastage?

1123

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2374

What is data analytics in simple terms?

1268

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

2248

What is the difference between drill through and masterdetail reports?

1247

How can you export a component’s internal parameters ?

2456

Is Redshift similar to RDS ?

Do you think effective communication is necessary for data processing?

1271

What makes sas stand out to be the best over other data analytics tools?

1119

How do we resolve attribute roles in microstrategy?

1205

How to call shell scripts from informatica?

1044

what is degenerate key in oracle ?whare do we use it?

2616

Explain what are the different types of join operations?

1021

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