Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

817

Mention few capabilities of sas framework.

696

What are the parameters of scan function?

627

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

583

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

843

How do you delete duplicate observations in sas?

581

Is hadoop a etl tool?

521

Is apache nifi an etl tool?

558

What is etl tool in hadoop?

502

Explain about power designer data modeling software?

469

Explain about the data integration suite features?

477

Explain about enterprise scalability and roi of data integration suite?

498

Give the benefits of data integration suite?

502

Explain about etl data integration software?

486

What is a lookup table in etl?

600


Un-Answered Questions { Data Warehouse }

Explain why are oltp database designs not generally a good idea for a data warehouse?

629


What is the maplet?

622


What are the fundamental elements of the data warehouse?

503


Explain the term 'database' related to relational database management system?

579


Explain how spool space is used.

623






What are situations where snowflake schema is better than star schema when the opposite is true?

568


where is the cache (lookup, index) created and how can you see it.

1571


When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

1918


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

1883


Explain how we drill up week to month?

645


What is the function of look up transformation?

657


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1535


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1660


What is the difference between server job and parallel jobs?

678


What exactly do you understand with the term data processing and businesses can trust this approach?

649