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

What is the use of Cognos scenario?

1242

What are all types of Batches?

1080

What do you mean by Drill down and Drill Up?

1056

How can bottlenecks be identified?

1067

What are the newly developed features of Teradata?

1089

Comment whether bottleneck is an error or not.

1226

Highlight all the modes that are present under Confidence Level.

1015

What is TPD?

1426

Highlight a few of the important components of Teradata?

1083

How do you define Teradata?

1087

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1265

Name the five phases that come under MultiLoad Utility.

1032

How can we check the version of Teradata that we are using currently?

1114

What are the primary characteristics of the Teradata.

1246

How is MLOAD Teradata Server restarted after execution?

1345

Un-Answered Questions { Data Warehouse }

How analytics process your request when you create your requests?

1000

What Is Snow Flake Schema?

1265

What is the goal of optimizer?

1098

can be used COM component in Informatica ?

2115

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1143

How do you remove duplicate values in datastage?

1198

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

what are all the reports you generated in your recent project?

2259

How many dimensions are there in informatica?

1139

What was the last computer book you purchased? Why?

2423

Mention few power centre client applications with their basic purpose?

1002

Explain what are components of reportnet?

1032

What should I have in mind when building olap solution from scratch?

1061

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

1096

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3430

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