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?

1194

What are all types of Batches?

1029

What do you mean by Drill down and Drill Up?

999

How can bottlenecks be identified?

1024

What are the newly developed features of Teradata?

1036

Comment whether bottleneck is an error or not.

1163

Highlight all the modes that are present under Confidence Level.

972

What is TPD?

1381

Highlight a few of the important components of Teradata?

1031

How do you define Teradata?

1041

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?

1207

Name the five phases that come under MultiLoad Utility.

991

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

1070

What are the primary characteristics of the Teradata.

1166

How is MLOAD Teradata Server restarted after execution?

1270

Un-Answered Questions { Data Warehouse }

What are the tools available for etl?

982

What is a passive transformation?

1110

whats the difference between previous version of cognos and cognos 8 BI?

5533

What is an expression transformation in informatica?

1045

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1278

Define metrics studio?

1049

What are data modeling and data mining? Where it will be used?

993

How to delete data which is not in source table?

1348

What function CATX syntax does?

1226

What is the precedence of stage variables,derivations, and constraints?

1086

what is the difference between querystudio in reportnet and cognos8

2139

what is index?how it can work in informatica

2045

What are the different types of scd's used in data warehousing?

1250

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1021

What are three tier systems in etl?

1067

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