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 enterprise class platform architecture of cognos 8?

1087

What are the services provided in cognos 8?

1084

Explain the different types of views used in cognos.

999

What are the main services provided by application tier?

1035

What are the roles defined by cognos platform?

1207

What is the importance of having monitor service in cognos?

1106

What are the considerations regarding performance kept in mind while setting up cognos?

1022

What are the components used in web tier?

1058

What is the difference between low affinity and high affinity connections?

1070

What are the different types of important services used in cognos?

1068

What is the function of cognos dispatcher?

1289

What is the use of powerplay web viewer in cognos?

1136

What are the different kinds of panes included in cognos?

1113

Why is auto-regression used in forecasting used on cognos platform?

1082

What is a folder? Difference types of stages?

1247

Un-Answered Questions { Data Warehouse }

I know of using applysimple, but there are other ways too?

1005

What subtotaling features does microstrategy desktop contain?

1053

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

1005

which r the connectors used in san?

2236

What makes sas stand out to be the best over other data analytics tools?

1119

Why did ibm cognos tm1 web change the technology from .net to java?

What is VLDB?

1119

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2488

When can we choose the Redshift ?

What is data cleaning?

1009

Give one reason when you need to consider multiple data processing?

1228

How will you create interactive dashboards ?

955

What are the common features of Redshift?

difference between repository database and repository service?

1233

Explain how to get the first 100 rows from the flat file into the target?

1034

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