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.

1079

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?

1060

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.

1105

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?

1188

Explain how spool space is used.

1076

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 }

Explain the characteristics of cognos?

1042

Is there any other repository domains rather than universe, security, document?

1046

How to create diff. Types of templates?

1050

How to find duplicates in a table?

1218

Can we use target hash file as a lookup ?

3327

Is there any difference in testing database and data ware housing?

2762

options available in sequence job to run,validate?

1318

Explain the difference between etl tool and olap tools?

908

How to calculate fact table granularity?

1020

How do you change a non-reusable transformation to reusable transformation?

999

How to extract sap data using informatica?

1043

What are the types of jobs we have in datastage?

1075

When we use aggregate awareness function in designer?

979

What is the meaning of decode in informatica?

1122

What parallelisms does Abinitio support?

1202

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