Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

Accenture, Quintiles,

3 6597

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

Accenture, Quintiles,

2183

what is p-value

Accenture, Quintiles, Sristek,

3 7328

what is null hypothesis? why do you consider that?

Accenture, Quintiles,

2418

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

Accenture, Quintiles,

1 7424

how do you derive descriptive statistics?

Accenture, Quintiles,

1 6751

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

Accenture, Quintiles,

2899

what kind of variables are collected in AE dataset?

Accenture, Quintiles, SAS,

3 12393

Baseline definition in your study

Accenture, Quintiles,

3 12500

What are the efficacy variables in your study?

Accenture, Quintiles,

2 11388

What procedure you used to calculate p-value?

Accenture, Quintiles,

2 9004

how do you validate tables abd reports?

Accenture, Quintiles,

2 7465

What are TEAEs

Accenture, Quintiles,

2 11859

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

Accenture, Quintiles,

3013

What are the rows present in protocol Violation table?

Accenture, Quintiles,

2 8303


Un-Answered Questions { Data Warehouse }

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1605


What are the main differences you have observed between 7.x and 8.x version of datastage?

624


Explain is olap databases are called decision support system true/false?

556


Why we use repository connectivity?

542


What is embedded metric?

566






What is InformaticaPowerCenter?

692


AE datasets names? how many types?

2078


Explain teradata utilities. What is multiload, fast load, tpump?

575


How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2385


What are the limitations of joiner transformation?

655


What is is a star schema?

567


can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1306


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2013


What according to you might be the future of data warehousing?

529


What are the tasks that source qualifier perform?

633