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

explain about various caches available in data integrator? : Sas-di

1120

what is change analysis in sas di ? : Sas-di

1118

what is hierarchy flattening? : Sas-di

1145

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1105

What are the prime responsibilities of data integration administrator? : Sas-di

1120

what are the benefits of data integration? : Sas-di

1185

what is snowflake schema? : Sas-di

1264

What are the different operating system platforms in which we can use sas? : sas-grid-administration

1131

How do you connect the desktop application to metadata server? : sas-grid-administration

1147

What are the different servers in sas? : sas-grid-administration

1105

In sas admin differentiate between roles and capabilities? : sas-grid-administration

1054

What is the role of unrestrictive users? : sas-grid-administration

1079

What is connection profile? : sas-grid-administration

1235

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1063

Name any two sas spawners? : sas-grid-administration

1098

Un-Answered Questions { Data Warehouse }

What Proc glm does?

1147

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2069

What do you mean by filter transformation?

1008

The same tier?

1143

Sequence generator, when you move from develoment to production how will you reset

2130

Name the types of report?

1013

Explain how to schedule the report in b.o?

1126

How many ways to overcome a missing values???

2870

Where the cache files stored?

1069

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2171

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7190

Give the advantages of cognos?

1092

What is the difference between STOP and ABORT options in Workflow Monitor?

1322

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1445

Explain difference between powerplay transformer and power play reports?

1002

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