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 are the different clients of powercenter?

1081

During the running session, output files are created by informatica server. Enlist few of them.

996

How to run a query in teradata?

1099

What is a node in teradata?

1008

What do you mean by teradata intelliflex?

1123

Explain fallback in teradata?

1074

What are different table types used in teradata?

1060

What is teradata and why it is used?

1116

What do you mean by teradata sql assistant?

1075

Explain parsing engine in teradata?

1107

What do you mean by fastexport in teradata?

1018

Explain vproc in teradata?

1018

What do you mean by ttu in teradata?

1056

What are teradata utilities?

1122

What is bteq script in teradata?

1169

Un-Answered Questions { Data Warehouse }

What are the various reporting tools in the market?

1085

What is a standalone command task?

1217

Explain teradata vs. Redshift?

1039

What is program data vector (pdv)?

1307

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1105

Where do we use mapping variables in informatica?

1085

Define metrics studio?

1054

What can you learn from the SAS log when debugging?

1401

What do the mod and int function do? : Sas programming

1244

Explain when to use local filter and when to use global filter?

1368

Differences between business objects and web intelligence reports?

1236

What does Amp contain and what are all the operations that it performs?

1015

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?

1111

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4402

What is the use of function Proc summary?

1299

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