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

for report generation which one you used proc report or data_null_?

Accenture, Quintiles,

3 7790

what is the Population you used in your project, is it ITT or PP?

Accenture, Quintiles,

2743

what is p-value

Accenture, Quintiles, Sristek,

3 8455

what is null hypothesis? why do you consider that?

Accenture, Quintiles,

2897

what is chi-square test? have you used that?

Accenture, Quintiles,

1 8222

how do you derive descriptive statistics?

Accenture, Quintiles,

1 7644

what are the considerations when picking a SAS/STAT procedure?

Accenture, Quintiles,

3374

what kind of variables are collected in AE dataset?

Accenture, Quintiles, SAS,

3 14043

Baseline definition in your study

Accenture, Quintiles,

3 13687

What are the efficacy variables in your study?

Accenture, Quintiles,

2 12508

What procedure you used to calculate p-value?

Accenture, Quintiles,

2 10119

how do you validate tables abd reports?

Accenture, Quintiles,

2 8421

What are TEAEs

Accenture, Quintiles,

2 12911

What are all the problems you faced while validating tables and reports?

Accenture, Quintiles,

3470

What are the rows present in protocol Violation table?

Accenture, Quintiles,

2 9468

Un-Answered Questions { Data Warehouse }

Is there any way to read the ms excel datas directly into informatica?

1022

How to limit the max no of rows retrieved in the report?

984

What is the maximum and minimum length of macro variable

1254

What are the types of schemas we have in data warehouse and what are the difference between them?

941

Define repository tables in datastage?

1157

How to Create a folder using pmrep command?

1173

What is the difference between star and snowflake schemas?

1213

what is the difference between the report filter and report limit?

970

How do you verify a complicated sql?

1063

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1010

How to fine tune mappings?

941

Explain object variable error?

994

How do dates work in SAS data?

1176

How we can use union transformation?

1051

Differentiate between datastage and informatica?

1181

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