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 PROC in SAS?

1059

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1112

What does PROC print, and PROC contents do?

1241

What is factor analysis?

1141

What is the maximum length of the macro variable?

1184

Describe 5 ways to do a “table lookup” in SAS?

1154

What is SAS?

1062

Which statement does not perform automatic conversions in comparisons?

1793

What are the special input delimiters used in SAS?

1188

What are the data types does SAS contain?

1120

What do you understand by the term Normal Distribution?

994

How to create list output for cross-tabulations in proc freq?

1114

What are the features of SAS?

1036

What is the basic syntax style in SAS?

1174

What function CATX syntax does?

1226

Un-Answered Questions { Data Warehouse }

What are the components used in web tier?

992

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2051

Code the tables statement for a single-level (most common) frequency?

939

What are your responsibilities as an etl tester?

1166

What is a data profile?

984

Define oconv () and iconv () functions in datastage?

1417

Define mapplet?

1018

What are the key benefits of ETL Testing?

1055

Explain difference between snow flake and star schema.

1056

What are some commonly used bteq scripts?

1022

How can we schedule the graph in unix?

1002

list and discuss two approaches for updation of target table in Informatica and how they are different.

2117

how do the in= variables improve the capability of a merge? : Sas programming

1439

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1102

Enlist the various types of transformations.

1062

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