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.

1231

Mention few capabilities of sas framework.

1150

What are the parameters of scan function?

1133

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

1060

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

1315

How do you delete duplicate observations in sas?

1040

Is hadoop a etl tool?

901

Is apache nifi an etl tool?

926

What is etl tool in hadoop?

861

Explain about power designer data modeling software?

824

Explain about the data integration suite features?

901

Explain about enterprise scalability and roi of data integration suite?

855

Give the benefits of data integration suite?

883

Explain about etl data integration software?

859

What is a lookup table in etl?

1135

Un-Answered Questions { Data Warehouse }

What is rank metrics in microstrategy?

946

How do you update the records with or without using update strategy?

1078

Define pmcmd command?

1010

What is defined as Cognos Impromptu?

1048

What are the different table types that are supported by teradata?

975

Explain clustering algorithm?

2232

Name the five phases that come under MultiLoad Utility.

947

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1947

What is MAX CORE of a component?

1272

What is an i-server? What are the different modes to run it?

947

What happens when a session fails and you click on recover?

1093

What is level based metrics.how will you create it?

822

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1620

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

1023

What is a method to debug and test your SAS program?

1308

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