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.

1213

Mention few capabilities of sas framework.

1126

What are the parameters of scan function?

1106

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

1031

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

1286

How do you delete duplicate observations in sas?

1008

Is hadoop a etl tool?

880

Is apache nifi an etl tool?

907

What is etl tool in hadoop?

837

Explain about power designer data modeling software?

798

Explain about the data integration suite features?

874

Explain about enterprise scalability and roi of data integration suite?

831

Give the benefits of data integration suite?

864

Explain about etl data integration software?

841

What is a lookup table in etl?

1105

Un-Answered Questions { Data Warehouse }

Explain how to get the first 100 rows from the flat file into the target?

916

What is data analysis?

896

What is decode in static cache?

1077

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2702

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2057

Why AWS redshift is named after Redshift?

What is the difference between slice and dice and cross tab report?

993

Explain clustering?

883

how to read the variables in sas? : Sas-administrator

962

if collect stats but it show low confidence why?

1618

Explain the data type of the surrogate key?

899

Can you execute a macro within a macro? Describe. : sas-macro

1067

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2767

What is a core dimension?

1011

In which transformation you cannot drag ports into it?

1243

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