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?

2144

what is the generated prompt,how can i use?

5 19560

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

2180

What is mean by tuning the report?

1 3165

what are they different types of report in BO?

6 32074

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

5 11723

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

5 26889

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 9393

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 15031

What are set operators in Oracle

Deloitte, Wipro,

3 16960

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 18993

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 39306

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 10645

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

1 5004

What is Target Update Override? What is the Use ?

Patni,

8 19497

Un-Answered Questions { Data Warehouse }

I have a flat file, want to reverse the contents of the flat file

1068

How can you define user defied event?

980

how many types prompting framework can be broken down to? : Sas-bi

1035

What are the key elements of a data processing system?

1142

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2224

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2009

What is the difference between informatica and datastage?

1148

What are the different types of scd's used in data warehousing?

1179

Difference between zabo and webi?

1052

How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1975

-----------------What is Direct and Conventional loading?

2124

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.

2147

Define views in teradata with general syntax.

984

What is full load & incremental or refresh load?

1155

Define meta stage?

1144

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