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 55031

What is use of compress in terdata?Explain?

11 36737

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

3 5543

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 3775

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 17225

wat is bus schema?

2 6424

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 8036

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 5116

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

6854

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

ME,

1 5228

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

PCS, Tech Mahindra,

6 15192

Why Fload doesn’t support multiset table?

9 29754

Why AMP & PE are called Vprocs?

4 16959

Explain about Skew Factor?

TCS,

6 53452

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

Accenture,

3 11928

Un-Answered Questions { Data Warehouse }

What is the difference between er modeling and dimensional modeling?

1195

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1146

What are the limitations of joiner transformation?

1183

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2251

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2303

Explain about compound key?

1148

Explain what Proc glm does?

1303

what is data access? : Sas-di

1187

How to eliminate product joins in a teradata sql query?

1090

What are the key features of chameleon that separates it from other algorithms?

1184

what will be the contents for a functional requirements specifications

2422

What are the advantages of teradata?

1064

What are the two types of framework manager?

1440

expain about the tune parameters?

2463

What is the difference between drill through, drill across?

1158

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