Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

800

Mention few capabilities of sas framework.

683

What are the parameters of scan function?

610

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

568

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

827

How do you delete duplicate observations in sas?

565

Is hadoop a etl tool?

509

Is apache nifi an etl tool?

538

What is etl tool in hadoop?

488

Explain about power designer data modeling software?

457

Explain about the data integration suite features?

468

Explain about enterprise scalability and roi of data integration suite?

488

Give the benefits of data integration suite?

492

Explain about etl data integration software?

480

What is a lookup table in etl?

586


Un-Answered Questions { Data Warehouse }

Differentiate between source qualifier and filter transformation?

990


Explain factless facts?

565


What leads to a cross-join or how does a cross-join occur?

546


How can we schedule the graph in unix?

552


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9867






How many steps etl contains?

524


What are the some differences between 7.x and 8.x version of datastage?

732


How can a transformation be made reusable?

658


Implementation methodology

1253


What do you understand by the term Normal Distribution?

566


What are the data types in sas?

598


Explain the difference between view and materialized view?

504


Do you know how to prioritize the excecution of a report?

545


Explain constraint based loading in informatica

653


Explain the difference between native sql and cognos sql?

502