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

List down the reasons for choosing sas over other data analytics tools.

1337

Mention few capabilities of sas framework.

1248

What are the parameters of scan function?

1224

What are the differences between sum function and using “+” operator?

1162

Given an unsorted data set, how to read the last observation to a new data set?

1414

How do you delete duplicate observations in sas?

1114

Is hadoop a etl tool?

1004

Is apache nifi an etl tool?

1021

What is etl tool in hadoop?

954

Explain about power designer data modeling software?

919

Explain about the data integration suite features?

1003

Explain about enterprise scalability and roi of data integration suite?

935

Give the benefits of data integration suite?

963

Explain about etl data integration software?

954

What is a lookup table in etl?

1239

Un-Answered Questions { Data Warehouse }

What is the max core of a component?

1155

While creating table my dba has fallback or no fallback in his ddl. What is that?

1246

How can we use mapping variables in informatica?

1125

What is by-group processing?

1059

define the logic behind the sparsity in cubes?

How can we run the graph? What is the procedure for that?

995

what is the use of server manager?

2199

What are routines in datastage? Enlist various types of routines.

1154

Differentiate between Load Manager and DTM?

2216

How big was your fact table

1864

Can we access multiple operational databases from within a single microstrategy project?

1102

What are the settings that you use to configure the joiner transformation?

1107

Terminate Activity

1342

Why null values are mapped as 0 in fact tables?

1050

How you can read the variables that you need?

1179

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