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

Mention a few of the ETL tools that come under Teradata.

1080

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171

Highlight the advantages of PPI(Partition Primary Index).

1078

What is meant by a Least Cost Plan?

1061

What is meant by a dispatcher?

1021

Highlight the points of differences between the database and user in Teradata.

1109

Explain BYNET.

1005

Highlight the need for Performance Tuning.

1106

In the Primary Index, what is the score of AMPs that are actively involved?

1078

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1260

What is meant by a Virtual Disk?

1136

What is meant by a Parsing Engine?

1189

Explain how spool space is used.

1077

What do you mean by parsing?

1113

Highlight a few of the advantages that ETL tools have over Teradata.

1090

Un-Answered Questions { Data Warehouse }

What is the difference between a cascading report and drill through report?

1073

Can you define pivot?

1113

In sas admin differentiate between roles and capabilities? : sas-grid-administration

1003

What are the types of data processing you are familiar with?

1217

How are indexes created after completing the load process?

1647

Describe link sort?

1015

Explain level extension?

1055

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2571

What is multi insert?

1053

why is a stop statement needed for the point=option on a set statement? : Sas programming

1086

How many types of transformations supported by sorted input?

1224

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2004

what is the purpose of _error_? : Sas programming

1140

how does sas handle missing values in sort order? : Sas programming

920

generate date / time dimension in informatica

1126

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