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.

1288

Mention few capabilities of sas framework.

1195

What are the parameters of scan function?

1180

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

1116

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

1358

How do you delete duplicate observations in sas?

1078

Is hadoop a etl tool?

955

Is apache nifi an etl tool?

968

What is etl tool in hadoop?

896

Explain about power designer data modeling software?

856

Explain about the data integration suite features?

954

Explain about enterprise scalability and roi of data integration suite?

882

Give the benefits of data integration suite?

924

Explain about etl data integration software?

894

What is a lookup table in etl?

1191

Un-Answered Questions { Data Warehouse }

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

2767

What DB View and Bus View?

1979

Describe the evaluation of parameters order in ab initio?

1534

How would you get two images on microstrategy login page?

991

What is the difference between absolute filtering and standard filtering?

1053

Can you define a catalog and types of catalogs in cognos?

1059

What is defined as catalog and types of catalogs in Cognos?

1141

How do u convert the columns to rows in datastage?

1198

What is the difference between informatica and datastage?

1235

Demonstrate experience in maintaining quality process standards?

2560

What are the various methods of getting incremental records or delta records from the source systems?

938

Explain constraint based loading in informatica

1103

What is the difference between one to one merge and match merge? Give an example.

1070

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1187

Explain the structure of cold fusion?

1045

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