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

1051

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

1060

what is hierarchy flattening? : Sas-di

1081

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

1050

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

1070

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

1108

what is snowflake schema? : Sas-di

1215

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

1072

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

1096

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

1057

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

1003

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

1008

What is connection profile? : sas-grid-administration

1173

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

1008

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

1039

Un-Answered Questions { Data Warehouse }

What are the types of studio present in Cognos?

1036

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2493

On which Dimension Table you implemented SCD Type in your Project

2044

how do you use tm1 cubes in framework manager?

What is the difference between metadata and data dictionary?

1141

How do you reject records in a transformer?

1124

Is possible to create skid in dim,fact tables?

2636

Steps to create a data model?

1133

How would you get two images on microstrategy login page?

989

what is the size of your data warehousing?

2095

Explain the difference between keylokup and joiner?

891

What is the syntax for case when statement?

1143

What are the key elements of a data processing system?

1245

Explain what is the data type of the surrogate key?

977

what is slowly changing dimension? : Sas-di

1128

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