Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

798

Mention few capabilities of sas framework.

680

What are the parameters of scan function?

607

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

565

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

823

How do you delete duplicate observations in sas?

562

Is hadoop a etl tool?

507

Is apache nifi an etl tool?

533

What is etl tool in hadoop?

486

Explain about power designer data modeling software?

457

Explain about the data integration suite features?

467

Explain about enterprise scalability and roi of data integration suite?

485

Give the benefits of data integration suite?

488

Explain about etl data integration software?

480

What is a lookup table in etl?

582


Un-Answered Questions { Data Warehouse }

What do you understand by term role-playing dimension?

563


Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1594


How to load last n records of file into target table - informatica

591


What is meant by metadata in context of a data warehouse and how it is important?

646


What do you mean by trimming sql in microstrategy?

515






When do we go for the tools in the market?

541


How to do the error handling of if ur source is flatfiles?

1500


Explain what is the difference between microstrategy and cognos reporting tool?

535


What are default access rights in teradata? What explicit right can be given to a user?

644


What are diagrams?

616


What is a data warehousing?

603


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3274


how do you create schema objects in 2 tier connection?

540


What is data stream and data adaopter?

603


How many data types are there in SAS?

620