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.

1146

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1221

Highlight the advantages of PPI(Partition Primary Index).

1142

What is meant by a Least Cost Plan?

1124

What is meant by a dispatcher?

1073

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

1180

Explain BYNET.

1057

Highlight the need for Performance Tuning.

1167

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

1151

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?

1372

What is meant by a Virtual Disk?

1217

What is meant by a Parsing Engine?

1241

Explain how spool space is used.

1122

What do you mean by parsing?

1171

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

1147

Un-Answered Questions { Data Warehouse }

what is information maps?

2290

why use references rather than pointers in the public api, particularly for arguments which are modified?

1063

What is the difference between proportion and average?

3412

How you will check the version of teradata?

1235

Can we create universe with no cache??

2581

what do you mean by custom groups?

1030

Do you view contain data?

1015

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

2230

How to delete data which is not in source table?

1401

What are symget and symput? : sas-macro

1378

How is the teradata different from oracle?

1174

Explain scan md?

1149

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1159

Which are the different editions of informatica powercenter that are available?

1086

How to run a graph infinitely?

1172

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