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 6781

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

Satyam,

2801

name few built in sas transformation in DI studio ?

SAS,

4 20934

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

4 12334

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

Misys,

2 11446

"how much experience you have in crystal report ?"

CTS, Infosys,

1 4838

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 20020

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

1 5244

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

3 13853

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

2 14747

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

2 6477

What is the difference between the prompt and cascading prompt

2 12552

is QUALCOMM using SAS ?

1 5351

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

L&T,

18 35732

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,

2510

Un-Answered Questions { Data Warehouse }

In which transformation you cannot drag ports into it?

1323

What is the function of surrogate key in data warehousing?

1076

How is MLOAD Teradata Server restarted after execution?

1270

what is stitch query in reportnet?

1107

how do you use tm1 cubes in framework manager?

What is the difference between the local container and shared container?

1108

Is Redshift a row based storage or columnar based?

How do you specify the number of iterations and specific condition within a single do loop?

1111

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2284

what is the difference between floor and ceil functions in sas? : Sas-administrator

1265

What are intelligent cubes?

1011

What is the difference between datastage and informatica?

1123

where are dashboard components are created and maintained? : Sas-bi

1017

What is report as filter in microstrategy?

920

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1970

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