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 the process to restart the multiload if it fails?

7 54785

What is use of compress in terdata?Explain?

11 36346

How to improve the performance of the report at the report level?

3 5443

A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt

1 3683

suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

TCS,

5 17039

wat is bus schema?

2 6311

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 7881

plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?

2 5030

how to explain health care project and which reports we can create in health care doain?

6806

why is the use of Retrive statement and give me with example?

ME,

1 5146

could you please give me the diagram of BO 6.5 Architecture or explain about the tires?

PCS, Tech Mahindra,

6 14989

Why Fload doesn’t support multiset table?

9 29450

Why AMP & PE are called Vprocs?

4 16776

Explain about Skew Factor?

TCS,

6 53205

WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

Accenture,

3 11772

Un-Answered Questions { Data Warehouse }

What are the approaches used by optimizer during execution plan?

911

What is the difference between set functions and filter function in dimensional data?

2918

How do you use reject loader.

2613

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1288

What a datastage macro?

1065

How you know when to use a static cache and dynamic cache in lookup transformation?

1857

How can we check the version of Teradata that we are using currently?

1070

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1116

What is level prompt?

965

Explain scd type 3 through mapping.

1023

What is the different type of jobs in datastage?

982

What is difference between data mart and data warehouse?

984

Can we collect statistics on table level?

1041

To save time, can many reports be run at the same time?

1034

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1498

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