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.

1217

Mention few capabilities of sas framework.

1130

What are the parameters of scan function?

1111

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?

1292

How do you delete duplicate observations in sas?

1015

Is hadoop a etl tool?

883

Is apache nifi an etl tool?

912

What is etl tool in hadoop?

839

Explain about power designer data modeling software?

801

Explain about the data integration suite features?

878

Explain about enterprise scalability and roi of data integration suite?

835

Give the benefits of data integration suite?

867

Explain about etl data integration software?

846

What is a lookup table in etl?

1109

Un-Answered Questions { Data Warehouse }

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2228

2. What functional area you worked on.

2277

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2078

How to create context?

955

How do you load alternate records into different tables through mapping flow?

1808

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

908

What are the various etl tools in the market?

1019

What is data stream and data adaopter?

1022

What is apt_config in datastage?

1084

What are the programs that we can do with the microstrategy architect?

970

What are the components provided on node?

987

which date function advances a date, time or datetime value by a given interval? : Sas programming

996

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1991

What is a snowflake schema?

930

what are the data modeling tools you have used?(polaris)

1941

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