Data Warehouse Interview Questions
Questions Answers Views Company eMail

List down the reasons for choosing sas over other data analytics tools.

794

Mention few capabilities of sas framework.

678

What are the parameters of scan function?

601

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

561

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

818

How do you delete duplicate observations in sas?

559

Is hadoop a etl tool?

503

Is apache nifi an etl tool?

530

What is etl tool in hadoop?

484

Explain about power designer data modeling software?

453

Explain about the data integration suite features?

467

Explain about enterprise scalability and roi of data integration suite?

482

Give the benefits of data integration suite?

486

Explain about etl data integration software?

478

What is a lookup table in etl?

574


Un-Answered Questions { Data Warehouse }

describe the Steps to confiure a Qlogic switch

1923


Whether dimension table can have numeric value?

588


what do you mean by custom groups?

547


What is main use of mapplet?

642


What are data-driven sessions?

702






what is repositery?

1280


What is bteq utility in teradata?

561


What are cluster in redshift? How do I create and delete a cluster in aws redshift?

1


Differentiate between sessions and batches?

558


What is program data vector (pdv)?

623


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

1658


Explain the datastage parallel extender (px) or enterprise edition (ee)?

713


have u done any performance tuning? how u ll do?

1847


What is domain in terms of informatica?

552


What are partition points?

550