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?

2188

what is the generated prompt,how can i use?

5 19815

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

2223

What is mean by tuning the report?

1 3269

what are they different types of report in BO?

6 32335

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

5 11923

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

5 27130

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 9548

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 15248

What are set operators in Oracle

Deloitte, Wipro,

3 17121

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 19297

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 40054

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 10747

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

1 5125

What is Target Update Override? What is the Use ?

Patni,

8 19833

Un-Answered Questions { Data Warehouse }

Explain what are the mapping paramaters and maping variables?

1070

What is amazon redshift odbc?

What is the maximum and minimum length of macro variable

1254

Please explain the different stages in creating a report in cognos report net?

1007

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

What is the difference between static and dynamic conditions?

1085

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1060

What are the advantages of cognos?

979

What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.

2601

How would you determine the number of missing or nonmissing values in computations?

1069

How would you include common or reuse to be processed along with your statements?

2373

Explain datawarehousing?

1044

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1074

What is difference between page break and section report?

1209

What is the difference between olap and oltp?

1057

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