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 are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?

Satyam,

1 6850

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

Satyam,

2846

name few built in sas transformation in DI studio ?

SAS,

4 21119

How to copy 1 million records from one DB to another, Which is effective interms of performance?

4 12497

How do I remove the hyperlink from the drill through report?

Misys,

2 11565

"how much experience you have in crystal report ?"

CTS, Infosys,

1 4923

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

TCS,

5 20243

what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?

1 5329

How do you download a flat file from Mainframe to your local PC using SAS?

3 13978

How do you add a prefix to some or all variables in a dataset using a SAS macro?

2 14868

How many universes are required for a single project,and how many reports are required for a single Universe.

2 6598

What is the difference between the prompt and cascading prompt

2 12697

is QUALCOMM using SAS ?

1 5421

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

L&T,

18 36297

what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

Magna Infotech,

2554

Un-Answered Questions { Data Warehouse }

Mention the difference between ‘macros’ and ‘prompt’?

1199

New coloums are added in database, then how you know in report level

1642

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1079

How to generate sequence numbers?

1139

What is difference between user and database in teradata?

1121

Explain security filter?

1125

How will effect the changes for a report , if for certain users only the column heading in the report should be changed?

851

can cubes contain measures ?

2078

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

2228

Describe the function and utility of the most difficult SAS macro that you have written?

2630

What is data encoding?

1319

Why does varchar occupy 2 extra bytes?

1277

What are the various tools used in etl?

1114

what is parallel query?

2134

How to use consolidations in microstrategy report?

1096

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