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.

1283

Mention few capabilities of sas framework.

1183

What are the parameters of scan function?

1176

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

1108

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

1355

How do you delete duplicate observations in sas?

1072

Is hadoop a etl tool?

942

Is apache nifi an etl tool?

962

What is etl tool in hadoop?

894

Explain about power designer data modeling software?

850

Explain about the data integration suite features?

945

Explain about enterprise scalability and roi of data integration suite?

879

Give the benefits of data integration suite?

921

Explain about etl data integration software?

887

What is a lookup table in etl?

1186

Un-Answered Questions { Data Warehouse }

How can we update a record in the target table without using update strategy?

1149

What is dimension modeling?

1088

What are the other names given to data warehousing?

1094

How do you load unique records into one target table and duplicate records into a different target table?

1259

What are connected or unconnected transformations?

1123

explain in detail about type 3?

1013

What is the difference between order and group variable in proc report?

1436

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

998

In Which Transformation We Can Use Having Clause In Informatica?

1242

How would you configure wh authentication? Explain.

997

how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

2284

-------------What is Coditional Prompting?

2150

Explain heterogeneous mapping?

984

What are the vldb properties? Which level of vldb configurations have the highest precedence?

942

What is the difference between a scan component and a rollup component?

1191

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