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.

1214

Mention few capabilities of sas framework.

1129

What are the parameters of scan function?

1110

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

1034

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

1290

How do you delete duplicate observations in sas?

1011

Is hadoop a etl tool?

882

Is apache nifi an etl tool?

911

What is etl tool in hadoop?

839

Explain about power designer data modeling software?

801

Explain about the data integration suite features?

877

Explain about enterprise scalability and roi of data integration suite?

833

Give the benefits of data integration suite?

867

Explain about etl data integration software?

843

What is a lookup table in etl?

1107

Un-Answered Questions { Data Warehouse }

How to elaborate powercenter integration service?

1075

What is the difference between microstrategy and cognos reporting tool?

921

What are all the types of gateway used in Cognos?

975

How would you load a very large file in teradata in general?

969

What are the differences between star and snowflake schema?

1003

What is the status code in stored procedure transformation?

1124

What is difference between query studio and report studio?

1035

When do we analyze the tables? How do we do it?

904

what actually happens when bulk load mode starts?

what is sas database server? : Sas-di

1054

What is cognos reporting tool?

1029

What is option by which we can run all the sessions in a batch simultaneously?

1082

How can you communicate with web server (apache or iis) from coldfusion?

1034

What could be the possible resons of locks by user?

1036

what is the role of transformer?

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