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 7801

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

Accenture, Quintiles,

2749

what is p-value

Accenture, Quintiles, Sristek,

3 8472

what is null hypothesis? why do you consider that?

Accenture, Quintiles,

2909

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

Accenture, Quintiles,

1 8226

how do you derive descriptive statistics?

Accenture, Quintiles,

1 7658

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

Accenture, Quintiles,

3381

what kind of variables are collected in AE dataset?

Accenture, Quintiles, SAS,

3 14063

Baseline definition in your study

Accenture, Quintiles,

3 13701

What are the efficacy variables in your study?

Accenture, Quintiles,

2 12516

What procedure you used to calculate p-value?

Accenture, Quintiles,

2 10137

how do you validate tables abd reports?

Accenture, Quintiles,

2 8436

What are TEAEs

Accenture, Quintiles,

2 12924

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

Accenture, Quintiles,

3478

What are the rows present in protocol Violation table?

Accenture, Quintiles,

2 9484

Un-Answered Questions { Data Warehouse }

Explain absolute filter?

988

What is looping and how to avoid it in framework manager?

1212

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1281

What is informatica architecture?

1070

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2115

Can you explain engine tier in information server?

1138

how many types of prompts are there? : Sas-bi

1082

What are the programs that we can do with the microstrategy architect?

1045

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1042

What is the difference between olap and datawarehosue?

961

waht type of interface is used for testing the data in informatica

2260

What is the profile and package?

2304

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2749

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1261

Tell e how how dealt with..

2256

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