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

1.What is caching? What are the different types of caching? 2.Is there any feature like summing total in crystal report?

Bhawan Cybertek,

2 8375

3.Can we use stored procedure for creating the report? 4.Does Crystal Report support all the functions that we have in Oracle?

Bhawan Cybertek,

1 6631

5.Can we add any database field once we have chosen ?Close? button?

1 5432

6.What are the sections that we have in Crystal reports?

Bhawan Cybertek,

2 8756

7.Are there any limitations in crystal reports? 8.Can we use our own SQL for creating a report?

Bhawan Cybertek, ICICI,

2 8689

9.Can we export data of reports into other format like in world doc etc? 10.Can we create report using more than one database?

Bhawan Cybertek,

1 6817

11.How do we format field? 12.How do we connect to the database?

Bhawan Cybertek,

1 6585

13.Can we use Crystal report as a stand-alone application?

Bhawan Cybertek,

2 17276

14.How to "Print" in Crystal Reports while using ASP DOT NET Platform?

Bhawan Cybertek,

2 10620

15.What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?

Bhawan Cybertek, CTS,

2 18533

What is source qualifier?

SDS,

6 31921

What is the Difference between DSS & OLTP?

5 12952

Explain grouped cross tab?

Accenture,

1 14504

What is the Hierarchy of DWH?

1 7899

How many repositories can we create in Informatica?

3 8810

Un-Answered Questions { Data Warehouse }

What is set to be cardinality?

1234

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1000

tell me the rules and responsblites in our project(my project is development)

1984

What are the enhancements made in datastage 7.5 compare with 7.0?

1218

how to generate the test data in sas without input data? : Sas-administrator

1186

Explain what are the mapping paramaters and maping variables?

1147

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

2011

How to pivot row data using informatica?

1020

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2129

What would you consider as your biggest achievement and why?

1068

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2551

Can we create a Integration service without a Repository service and vice versa?

1260

Mention what are the data types does SAS contain?

1196

What is meant by a domain?

1189

Describe crosslist option in tables statement?

1274

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